CurrentUser vs SelectedUsers

Hi WinterMist ,

Please follow these steps:

1.        Add two tables ,DO NOT create relationships.

(1)Table

Table = 
SUMMARIZE ( City, City[City ID], City[City Name], City[ID-City] )

(2)Table 2

Table 2 = 
SUMMARIZE ( User, User[User ID], User[User Name], User[ID-User] )

Relationship

2.        add new measure Table_City id & Table_ID-User

Table_City id

Table_City id = 
VAR _1 =
    SELECTEDVALUE ( 'Table'[ID-City] )
VAR _2 =
    IF ( MAX ( City[ID-City] ) = _1, MAX ( Sales[City ID] ), BLANK () )
RETURN
    _2

Table_ID-User

Table_ID-User = 
VAR _1 =
    SELECTEDVALUE ( 'Table 2'[ID-User] )
VAR _2 =
    IF ( MAX ( User[ID-User] ) = _1, MAX ( User[User Name] ), BLANK () )
RETURN
    _1

3. final output

March or not = 
VAR _1 =
    CALCULATE (
        MAX ( User[User Name] ),
        FILTER ( ALL ( User ), User[ID-User] = [Table_ID-User] )
    )
RETURN
    IF ( [Table_City id] <> BLANK () && MAX ( User[User Name] ) = _1, 1, 0 )

How to Get Your Question Answered Quickly - Microsoft Fabric Community

If it does not help, please provide more details with your desired out put and pbix file without privacy information.

^{Best Regards,}

^{Yifan Wang}

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