Forum Discussion
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...
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.
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.
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])) )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