Explanation: SUM(Sales[SalesAmount]) calculates the total SalesAmount for the entire dataset. CALCULATE modifies the filter context by adding a filter for Sales[Region] = "West". Therefore, TotalSalesWest will only consider sales where the Region is "West."
@Analystmind
2 күн бұрын
In this example, the filter context restricts the rows to only those where the Region is "West" before performing the calculation, resulting in a different outcome compared to calculating the total sales for all regions.
Пікірлер: 9