topic Need Help on dax formula in DAX Commands and Tips

Need Help on dax formula

bdkanand — Sat, 30 May 2020 02:07:55 GMT

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} )

Re: Need Help on dax formula

Pragati11 — Tue, 19 May 2020 16:19:21 GMT

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

Re: Need Help on dax formula

Anonymous — Wed, 20 May 2020 01:31:04 GMT

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490