Help with If Statement

Hi, I am new to Power Bi and currently havving challenges in creating an IF Statement. Here's what I am trying to accomplish. Status column is in Table 1 Sales count, Price and Quanti...

v-yulgu-msft

8 years ago

Hi jhen_1020,

If [Status], [Sales count], [Price] and [Quantity] are all added into the same visual, please try this similar measure:

If Status =
IF (
    SELECTEDVALUE ( 'Table1'[Status] ) = "OLD",
    SELECTEDVALUE ( Table2[Price] ) / SELECTEDVALUE ( Table2[Sales Count] ),
    SELECTEDVALUE ( Table2[Price] ) / SELECTEDVALUE ( Table2[Sales Count] )
        * SELECTEDVALUE ( Table2[Quantity] )
)

Regards,

Yuliana Gu

Forum Discussion

Help with If Statement

Related content

OR Statement ?

SQL Statement opcion error

Support for MERGE statement

New Column with IF STATEMENT

IF Statement using Power Query