Forum Discussion
Solved
Finding minimum rank per date
Hello, I am currently stuck with a problem. I have a rank column which ranks Columns with ID as per the ranking list. I wanted to find out the best rank as per the day. If the same ID has 3 diffe...
Thank you for your help Mahesh0016 .I had forgotten to put DISTINCT(File Date) in the formula to get the minimum rank for each date. The thing worked as soon as I changed the formula to:
Best Rank = CALCULATE(IF(SELECTEDVALUE('All Detailed APR'[Status])="ANSWERED",CALCULATE(MIN('All Detailed APR'[Rank]),
DISTINCT('All Detailed APR'[File Date]),ALLEXCEPT('All Detailed APR','All Detailed APR'[ID Number])),8))
Thank you for your help Mahesh0016 .I had forgotten to put DISTINCT(File Date) in the formula to get the minimum rank for each date. The thing worked as soon as I changed the formula to:
Best Rank = CALCULATE(IF(SELECTEDVALUE('All Detailed APR'[Status])="ANSWERED",CALCULATE(MIN('All Detailed APR'[Rank]),
DISTINCT('All Detailed APR'[File Date]),ALLEXCEPT('All Detailed APR','All Detailed APR'[ID Number])),8))