Forum Discussion

romovaro's avatar
romovaro
Responsive Resident
3 years ago
Solved

Filters

HI all,   I have a question regarding a filter:     I have a column called "Region of Implementation Consultant" I need to create a Region filter to see if number of regions in the scope ...
Need Help
  • romovaro's avatar
    romovaro
    3 years ago

    HI Stephen

     

    I got the solution.

     

    # of Regions=

    CALCULATE (

        DISTINCT COUNT ('Weekly Slippage' [Region of Implementation Consultant] ),

         ALLEXCEPT ('Weekly Slippage' ,'Weekly Slippage' [CID] )

    )

     

     

    thanks anyway

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi romovaro ,

 

Sorry, not very clear.

Is there any connection between the number of the region and the field of the slicer?

Whether the number of the region corresponds to the value of the slicer field, or whether the number of the region is related to the number of slicer field filters.

 

 

 

Best Regards,

Stephen Tao

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • romovaro's avatar
    romovaro
    Responsive Resident
    3 years ago

    HI Stephen

     

    I got the solution.

     

    # of Regions=

    CALCULATE (

        DISTINCT COUNT ('Weekly Slippage' [Region of Implementation Consultant] ),

         ALLEXCEPT ('Weekly Slippage' ,'Weekly Slippage' [CID] )

    )

     

     

    thanks anyway