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’
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…
When posting a question like this, you will always get the best response if you also post a copy of your PBIX file. Particularly for DAX-related questions, in order to provide a specific solution those responding to your post will usually also need to look your data model, since if that is not set up correctly even DAX that looks right may produce inaccurate/unexpected results.
