Forum Discussion

sabeensp's avatar
sabeensp
Icon for Helper IV rankHelper IV
7 years ago
Solved

Ignore Multiple Slicers in Measure

Hello, I have a Measure COUNT(Employees) I have mutiple slicers on the report Slicer1: Year Slicer2: Location Slicer3: Gender I need to divide Count of Employees selected by slicer values / All...
Need Help
  • v-chuncz-msft's avatar
    v-chuncz-msft
    7 years ago

    sabeensp 

     

    You may try ALL without arguments.

    Measure =
DIVIDE (
    COUNTROWS ( Employees ),
    CALCULATE ( COUNTROWS ( Employees ), ALL () )
)
v-chuncz-msft's avatar
v-chuncz-msft
Icon for Community Support rankCommunity Support
7 years ago

sabeensp 

 

You may try ALL without arguments.

Measure =
DIVIDE (
    COUNTROWS ( Employees ),
    CALCULATE ( COUNTROWS ( Employees ), ALL () )
)