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.
I have created the below formula to identify how many times in an 8 week period the user did not meet the 96% threshold. We created the following formula, but instead of returning a "1" to indicate the threshold had not been met, it gives values greater than 1. Could you please help to create correct dax formula.
Threshold= calculate ( 'consistency data' [ rc threshold] IN {1} )
HI @bdkanand ,
First thing I don't understand what your formaula is doing. Is it syntactically correct?
The link you shared soesn't work.
In order to check your threshold, you can create a calculated column using DAX something like shown below:
checkThreshold = IF(Table[threshold] < 0.96, 1, 0)
Replace the highlighted element above with your table threshold column. Also, I have assumed your threshold column contains values in decimal format. If not you can modify the DAX above accordingly.
If this helps and resolves the issue, appreciate a Kudos and mark it as a Solution! 🙂
Thanks,
Pragati
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 |
---|---|
41 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
43 | |
36 | |
33 | |
18 | |
18 |