IF ELSE to DAX

[kevinsray]

Hi all,

I am really having trouble getting the following formula to work in DAX.

If TABLEA.CHECK = "Y" THEN QTY = TABLEB.QTY * TABLEA.PerCarton
ELSE
QTY = TABLEB.QTY

TABLEA.CHECK is Text.

TABLEA.PerCarton is a number.

TABLEB.QTY is a number.

There is a 1 to many relationship on TABLEA.STOCKCODE to TABLEB.STOCKCODE (both Text)

If anyone is able to give any advice it would be greatly appreciated.

[AkhilAshok · Accepted solution]

There are multiple ways you can do this with measure. An easy way is as below:

Total Quantity =
SUMX (
    TABLEB,
    IF (
        RELATED ( TABLEA[CHECK] ) = "Y",
        TABLEB[QTY] * RELATED ( TABLEA[PerCarton] ),
        TABLEB[QTY]
    )
)

[kevinsray]

Thank you very much.
This worked perfected. RELATED was the function which I needed...