Count of unfiltered data from slicer

[Anonymous]

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.

[PattemManohar · Accepted solution]

@Anonymous  Please try this as a New Measure

Test309 = 
VAR _Selection = SELECTEDVALUE(Test309SlicerExclusion[Mode])
RETURN CALCULATE(COUNTROWS(Test309SlicerExclusion),NOT Test309SlicerExclusion[Mode] IN {_Selection})

Sample Test Data

[Anonymous]

@PattemManohar 

Thank you so much.. It's working.. 🙂