Need Help with DAX Calculations

[Anonymous]

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.

[amitchandak · Accepted solution]

@Anonymous , use hasonevalue

if(isfiltered(Table[Type]) && HASONEVALUE(Table[Type]) , 0, sum(Table[result]))

refer: https://www.youtube.com/watch?v=hXg3kRFSGjA