Forum Discussion
MikhailGG
Helper I
Helper ISwitch with Multiple Hasonevalue() gives wrong results
I have the following formula Overview_Switch = switch( true(), HASONEVALUE('Data'[Region]), median('Sales_by_Region'[Total]), ...
iffiltered() insted of hasonevalue() solved the issue for me
Deku
Super User
Super UserCan you share your data model, I think you're problem is modelling maxing the DAX much more complicated than it needs to be.
Realistically you should
- Geography dimension( region and country)
- Functional area dimension
- Manager dimension
- Sales fact
Then the measure would just be median( sales[offical_total] ) and you can slice and dice however you want.
Your current issue what happens if some selects filter from multiple slicers, they will likely get misleading results
- Tutu_in_YYC
this ☝️
