Last answered:

25 Oct 2025

Posted on:

25 Oct 2025

0

Question regard section6 task four Part2 :

When calculating the total sales of US, why you didn't use the filter ?
2 answers ( 0 marked as helpful)
Instructor
Posted on:

25 Oct 2025

0
Hi, use the filter in what context?
Posted on:

25 Oct 2025

0
I was thinking that since we need to calculate the total sales only for US, when we use Calculate function, we will filter the calculation fusing only US sales: 

USToltasales = CALCULATE(SUM(fact_InternetSales[SalesAmount]),Filter( dim_SalesTeritory[SalesTerritoryCountry]="United states")

Submit an answer