Resolved: Card visual blank if we use [TotalSalesAmount] instead of SUM(fact_InternetSales[SalesAmount]. Why?
We have defined the measure TotalSalesAmount = SUM(fact_InternetSales[SalesAmount])
If I use
SalesAmountUnitedStates = CALCULATE([TotalSalesAmount], FILTER(dim_SalesTeritory, dim_SalesTeritory[SalesTerritoryCountry] = "United States"))
and then select "Australia", the card visual appears blank:
If I use
SalesAmountUnitedStates = CALCULATE(SUM(fact_InternetSales[SalesAmount]), dim_SalesTerritory[SalesTerritoryCountry]="United States")
the card visual shows a number:
Why this difference?
1 answers ( 1 marked as helpful)
Because of the way the filter context works. When you explicitly say FILTER(TableA, Condition) DAX only sees rows where we have United States. When you don't use the FILTER condition, the engine will replace the result for other selections with what you have included in the filtering condition. You get results for US for Australlia, Canada, France, etc