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.
Dears,
I'm looking for your usual support as I am facing an issue on how to do the measure what i need as below:
I want to do a KPI measurement on how many change request dose the project number has if it has 3 or less than CR ID it would be within target if other than this would be below target so the comparing between ( Project Number and CR ID)
Kindly advise me in this matter
Solved! Go to Solution.
HI @abeerq ,
Please try to use following measure if it works for your requirement:
Measure = VAR currID = SELECTEDVALUE ( Table[CR ID] ) VAR currCount = COUNT ( table[Project] ) RETURN IF ( currCount = 3 || currCount < currID, "Within", DIVIDE ( currCount, currID, 0 ) )
If above not help, please share some sample data and expected result for test.
Regards,
Xiaoxin Sheng
HI @abeerq ,
Please try to use following measure if it works for your requirement:
Measure = VAR currID = SELECTEDVALUE ( Table[CR ID] ) VAR currCount = COUNT ( table[Project] ) RETURN IF ( currCount = 3 || currCount < currID, "Within", DIVIDE ( currCount, currID, 0 ) )
If above not help, please share some sample data and expected result for test.
Regards,
Xiaoxin Sheng
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 |
---|---|
111 | |
94 | |
83 | |
66 | |
59 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |