Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Ranking based on multiple criteria

Hi All,    I have the following data:  Name Status DateTime A 1 2020/01/05 17:59:57 A 1 2020/01/05 17:59:59 A 2 2020/01/05 17:59:35 B 1 2020/01/05 17:59:54 B 1 2020/0...
Need Help
parry2k's avatar
parry2k
Icon for Super User rankSuper User
6 years ago

Anonymous it is very well explained in this post, just follow the instructions on how to rank category and sub category which is the use case for you.

 

Would appreciate Kudos 🙂 if my solution helped.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    parry2k,amitchandak: I tried that solution provided by and my query looks following: 

    Ranking by Sub Category =
        RANKX (
            FILTER(
                ALL(
                   --DateTime Column
                    WorkItemCompltd[operationutcdttm],
                   -- Status
                    WorkItemCompltd[workitemstatus]
                    ),
                --datetime column (Filter1)
                WorkItemCompltd[operationutcdttm] = MAX(WorkItemCompltd[operationutcdttm])
                ),
                ---Filter 2 (status)
                CALCULATE(MAX(WorkItemCompltd[workitemstatus]))
                )
     
    This ranks everything as 1. Please correct me if i am wrong somewhere.
    • parry2k's avatar
      parry2k
      Icon for Super User rankSuper User
      6 years ago

      Anonymous try this. seems like you didn't try to read the post but just followed the dax, try to understand the concept.

       

      RANKX (
        FILTER(
            ALL(
               --DateTime Column
                WorkItemCompltd[Name],
               -- Status
                WorkItemCompltd[workitemstatus]
                ),
            --datetime column (Filter1)
            WorkItemCompltd[workitemstatus] = MAX(WorkItemCompltd[workitemstatus])
            ),
            ---Filter 2 (status)
            CALCULATE(MAX(WorkItemCompltd[operationutcdttm]))
            )

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        parry2k : With the last solution it ranks everything as "1". 

        I went through the article again and now understood to get all the row we have two columns as input to ALL