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 Quanti...
  • 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

     

Phil_Seamark's avatar
Phil_Seamark
Icon for Microsoft Employee rankMicrosoft 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?

  • jhen_1020's avatar
    jhen_1020
    Regular Visitor
    8 years ago

    Hi, I am trying to add a measure.