Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 different ranks in a day it should show me the best rank for that day. Instead what it is doing is, giving me the best rank from all the dates of its entry. Here are the DAX I'm Using:
Thank You for your help!
Solved! Go to Solution.
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]),
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]),
I am trying to find the Best Rank for each date and not the best rank (minimum value) amongst all the dates. Like for File Date value 8th December the minimum is 2 as the two values are 2 and 8 so minimum for that day is 2 instead of 1 which is minimum amongst all the dates. Something like this:
>>Create Calculated column.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
96 | |
95 | |
80 | |
74 | |
66 |
User | Count |
---|---|
130 | |
106 | |
105 | |
86 | |
72 |