Ignore Selections "DAX Function ALL" not working

0
votes

I got a situation here, i have a measure for "Total Sales" with following expression

Total Sales = CALCULATE(SUM(Sale[total]), ALL(Customer))

I have a visualization in which i am displaying product-sales by customer.

If i make a customer-name selection in that visualization then this measure (mentioned above) changes its value. Why?

Both scenarios are shown in following screenshot (measure-value without customer-name selection & measure value with customer-name selection:

enter image description here

Data-Model Screenshot: enter image description here

1
powerbidaxpowerbi-desktop
because you are selecting an entire row, so your total is now filtered by product name (Laptop). – RADO

1 Answers

1
votes

I changed the formula to ignore both tables

Total Sales = CALCULATE(SUM(Sale[total]), ALL(Customer), ALL(Product))