Forum Discussion

rommel20's avatar
rommel20
Icon for Resolver I rankResolver I
9 years ago
Solved

DAX Grouping (tagging)

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.

 

Need Help
  • v-chuncz-msft's avatar
    v-chuncz-msft
    9 years ago

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

3 Replies

  • v-chuncz-msft's avatar
    v-chuncz-msft
    Icon for Community Support rankCommunity Support
    9 years ago

    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" )
  • prateekraina's avatar
    prateekraina
    Icon for Memorable Member rankMemorable Member
    9 years ago

    Hi rommel20,

     

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

     

    Prateek Raina