Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
3 years ago
Solved

Custom multi-location slicers

Good afternoon, I have the following problem, in one column I have the cities that have assigned the staff, there are staff that have only 1 as there are others that have 19 cities, they all regi...
  • v-easonf-msft's avatar
    v-easonf-msft
    3 years ago

    Hi, Syndicate_Admin 

    Please check if formula below could help:

    Count =
VAR _count =
    CALCULATE (
        COUNT ( Table1[Data.Tags] ),
        CONTAINSSTRING ( Table1[Data.Tags], MAX ( Table2[CD] ) )
    )
RETURN
    IF ( ISFILTERED ( Table2[CD] ), _count, COUNT ( Table1[Data.Tags] ) )

    If it doesn't work, please share more details.

    Best Regards,
    Community Support Team _ Eason