DAX Grouping (tagging)

[rommel20]

Need help, I need to tagged record if retain or removed based on its status and it grouping

But  the rules are

1: For each Unit, filter out Pros records if there exists an Exec record

2: For each Unit, filter out Vacant records if there exists a Pros record

so if it cointain one Unit it will retain else need to use the rule above.

Im trying to use contains and group by but still i  got incorrect Ouput.

[v-chuncz-msft · Accepted solution]

@rommel20,

You may check if RANKX Function works.

Rules (tagging) =
VAR Rnk =
    RANKX (
        CALCULATETABLE ( Table1, ALLEXCEPT ( Table1, Table1[Property], Table1[Unit] ) ),
        SWITCH ( Table1[Status], "Exec", 1, "Pros", 2, "Vacant", 3 ),
        ,
        1
    )
RETURN
    IF ( Rnk = 1, "Record remains", "Record removed" )

[rommel20]

its working. thanks.

[prateekraina]

Hi @rommel20,

Sorry, but i am not able to understand your problem. Can you re phrase what are you doing exactly?

Prateek Raina