Filters

[romovaro]

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 has an impact on the time?

Same as the column "#Regions in Scope" but in Filter.

Filter should show 1 (if only onre region), 2 (if 2 regions affected), 3 (if 3 regions), etc..

any help would be appreciated

Thanks

[Anonymous]

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 · Accepted solution]

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

[lbendlin]

Please provide sanitized sample data that fully covers your issue.
Please show the expected outcome based on the sample data you provided.