Forum Discussion
Need Help with DAX Calculations
Hi Community, I have a scenario in a particular calculation, where if there is a multiple selection in the slicer then the calculation should show the desired result, if the value is in single selection the value should show as "Zero".
Suppose A, B and C are values are there is a drop down slicer for A, B and C. If I just only a single value from Type in the slicer dorpdown then the result should show as "0", if there is multiple selection it should show the actual result.
Anonymous , use hasonevalue
if(isfiltered(Table[Type]) && HASONEVALUE(Table[Type]) , 0, sum(Table[result]))
1 Reply
Anonymous , use hasonevalue
if(isfiltered(Table[Type]) && HASONEVALUE(Table[Type]) , 0, sum(Table[result]))