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
Super 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