topic Re: DAX statement that uses a formula for TRUE and 0 for False returning error in DAX Commands and Tips

DAX statement that uses a formula for TRUE and 0 for False returning error

MBWATSON — Thu, 27 Jun 2024 00:05:23 GMT

Hi all! I am a novice at DAX and am trying to write an IF statement

SLOTS TO REACH 92% = Name of Measure

CALCULATE(IF('FILL RATE QUERY'[% FILLED] <.92), Expression

(.92 - 'FILL RATE QUERY'[% FILLED]) * ('FILL RATE QUERY'[CONTRACT HOURS] /2), If TRUE

0) If FALSE

%Filled is a measure. Contract Hours is a column I created in Power Query.

I am getting this error message

Too few arguments were passed to the IF function. The minimum argument count for the function is 2.

Hoping for some help to figure out what is missing/wrong. Thanks in advance!

Re: DAX statement that uses a formula for TRUE and 0 for False returning error

aduguid — Thu, 27 Jun 2024 00:23:45 GMT

You just had an end ")" after the .92

SLOTS TO REACH 92% = CALCULATE( IF('FILL RATE QUERY'[% FILLED] < 0.92 , (0.92 - 'FILL RATE QUERY'[% FILLED]) * (DIVIDE('FILL RATE QUERY'[CONTRACT HOURS], 2, 0) ) , 0 ) )

I would also suggest either storing the percent as a measure or variable.

SLOTS TO REACH 92% = VAR _percent_reach = 0.92 VAR _result = CALCULATE( IF('FILL RATE QUERY'[% FILLED] < _percent_reach , (_percent_reach - 'FILL RATE QUERY'[% FILLED]) * (DIVIDE('FILL RATE QUERY'[CONTRACT HOURS], 2, 0) ) , 0 ) ) RETURN _result

Re: DAX statement that uses a formula for TRUE and 0 for False returning error

MBWATSON — Thu, 27 Jun 2024 17:59:43 GMT

aduguid Thank you for the quick response! When I try to use either of these "FILL RATE QUERY' [CONTRACT HOURS] is no longer an option and I get an error message when I try to use it. Any suggestions?

Re: DAX statement that uses a formula for TRUE and 0 for False returning error

MBWATSON — Thu, 27 Jun 2024 18:12:10 GMT

aduguid , finally got it to work using this

SLOTS TO REACH 92% =

CALCULATE(

IF('FILL RATE QUERY'[% FILLED] <.92

,(.92 - 'FILL RATE QUERY'[% FILLED]) * (DIVIDE(MIN('FILL RATE QUERY'[CONTRACT HOURS]),2)))

)