Solved: Re: DAX Grouping (tagging)

rommel20 · ‎06-05-2017

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 · ‎06-06-2017

@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" )

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

v-chuncz-msft · ‎06-06-2017

@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" )

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.