The 365 Data Science team is proud to invite you to our own community forum. A very well built system to support your queries, questions and give the chance to show your knowledge and help others in their path of becoming Data Science specialists.
Ask
Anybody can ask a question
Answer
Anybody can answer
Vote
The best answers are voted up and moderated by our team

Purpose of the All function

Purpose of the All function

0
Votes
0
Answer

Hi everyone,
When I was going over the solution for Task 4 part 3 in the Power BI module, I came across the following DAX:
Total_Sales_Percentage = DIVIDE([TotalSalesAmount],
CALCULATE(SUM(fact_InternetSales[SalesAmount],
ALL(dim_SalesTeritory[SalesTerritoryCountry]),
ALL(dim_SalesTeritory[Country_Column])))*100
 
I know the DAX calculates the total percentage of sales by country but I don’t understand why two ALL functions
are needed to make the function work. I didn’t quite understand the video’s explanation for why this is so an alternative
explanation will be really helpful. 

No answers so far.