topic Re: How to convert SQL case statement to dax in DAX Commands and Tips

How to convert SQL case statement to dax

Anonymous — Tue, 02 May 2023 04:41:35 GMT

case
when (COALESCE(sum(ABC),0) - COALESCE(sum(ABCD),0)) < 0 then 0
else (COALESCE(sum(ABC),0) - COALESCE(sum(ABCD),0)) / sum(XYZ)

Re: How to convert SQL case statement to dax

eliasayyy — Tue, 02 May 2023 07:36:59 GMT

hello please try

IF( CALCULATE(SUM('Table'[ABC])) - CALCULATE(SUM('Table'[ABCD])) < 0, 0, DIVIDE( CALCULATE(SUM('Table'[ABC])) - CALCULATE(SUM('Table'[ABCD])), SUM('Table'[XYZ]) ) )

Re: How to convert SQL case statement to dax

Anonymous — Tue, 02 May 2023 09:29:33 GMT

Thank you for the reply. Somehow the last bit which is

SUM('Table'[XYZ])

is actually a measure and DAX is not picking up with this syntax and also coming with this error

so incase if you can help me further thank you

Re: How to convert SQL case statement to dax

eliasayyy — Tue, 02 May 2023 11:49:21 GMT

can you please show me the full measure how you wrote it

or please try

Measure = VAR result = SUM('Table'[ABC]) - SUM('Table'[ABCD]) RETURN IF( result < 0, 0, DIVIDE( result, SUM('Table'[XYZ]), 0 ) )