Forum Discussion

jhen_1020's avatar
jhen_1020
Regular Visitor
8 years ago
Solved

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 Quantity is in Table 2

 

What I want is something like this: If Status = "OLD",Price/ Sales Count else Price/ Sales Count times Quantity. 

 

Appreciate any response. 

 

Thank You!

  • v-yulgu-msft's avatar
    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

     

6 Replies

  • Phil_Seamark's avatar
    Phil_Seamark
    Microsoft Employee
    8 years ago

    HI jhen_1020

     

    Are you trying to add a calculated measure or column?  If you are trying to add a calculated column, which of the tables are you adding it to?

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    8 years ago

    Hi,

     

    Is there a connecting column between the 2 datasets?  If yes, then which one is it?

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft Employee
    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