I’m currently taking the ‘Mastering DAX Calculations’ Course and was thinking that I was starting to understand. But I had to figure the fact that I’m not so close to understand than I thought.
Here the situation:
- I have a date slicer
- I have a channel slicer
- I want to show in a table visual ALWAYS the ‘Sales per Channel’
– NO slicer/filter etc. should influence that table visual.
So, I use this measure to calculate the ‘Sales per Channel’
Sales per Channel =
CALCULATE( [Total Sales]; ALL( Dates[Date] ); ALL( Customers[Customer Names] ) )
The Channel slicer is still influencing the table, which it should not.
When I add the Channel with the ALL function to CALCULATE I only get the Total Total Sales without differenciating the channels.
I don’t have a clue for this.
Can someone please help…