How to convert calculate IF DAX statement column to measure?

[yoav20007]

Hi,
how to write the measure of IF function?
i succeeded just calculate column.
i wont to use a measure instead of calculate column

This calculate column work
sum_if_true2 = IF((sh[asmbly])=TRUE(),[total sale],0)

This dax doesn't work
sum_if_true = IF(VALUES(sh[asmbly])=TRUE(),[total sale],0)

Thanks

[Anonymous · Accepted solution]

Hi @yoav20007,

You can try below formula, I use 'lastnonblank' function to get current row contents:

sum_if_true2 =
VAR _current =
    LASTNONBLANK ( sh[asmbly], [asmbly] )
RETURN
    IF ( _current, [total sale], 0 )

Reference link:

LASTNONBLANK Function (DAX)

Regards,
Xiaoxin Sheng

[Ashish_Mathur]

Hi,

Try this

=CALCULATE(SUM(sh[sales]),FILTER(sh,sh[asmbly]=TRUE()))

Hope this helps.

[Anonymous · Accepted solution]

Hi @yoav20007,

You can try below formula, I use 'lastnonblank' function to get current row contents:

sum_if_true2 =
VAR _current =
    LASTNONBLANK ( sh[asmbly], [asmbly] )
RETURN
    IF ( _current, [total sale], 0 )

Reference link:

LASTNONBLANK Function (DAX)

Regards,
Xiaoxin Sheng

[yoav20007 · Accepted solution]

Thank you @Anonymous