Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi All,
I have a three mode, If I select one mode in slicer then is should show countof other.
Ex: I have three mode data "Air", "Ocean" and "Rail". If I slecect mode "Air" in slicer then it should show me count of mode "Ocean and Rail" so on...
Please any one help me with this, I am trying DAX function for this from long.
Thank you.
Regards,
Sachin.
Solved! Go to Solution.
@Anonymous Please try this as a New Measure
Test309 = VAR _Selection = SELECTEDVALUE(Test309SlicerExclusion[Mode]) RETURN CALCULATE(COUNTROWS(Test309SlicerExclusion),NOT Test309SlicerExclusion[Mode] IN {_Selection})
Proud to be a PBI Community Champion
@Anonymous Please try this as a New Measure
Test309 = VAR _Selection = SELECTEDVALUE(Test309SlicerExclusion[Mode]) RETURN CALCULATE(COUNTROWS(Test309SlicerExclusion),NOT Test309SlicerExclusion[Mode] IN {_Selection})
Proud to be a PBI Community Champion
User | Count |
---|---|
101 | |
90 | |
80 | |
71 | |
69 |
User | Count |
---|---|
114 | |
98 | |
97 | |
73 | |
72 |