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

     

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
8 years ago

Hi,

 

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

  • jhen_1020's avatar
    jhen_1020
    Regular Visitor
    8 years ago

    the two tables are connected by name. 

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Icon for Super User rankSuper User
      8 years ago

      Hi,

       

      Share the dataset and show the expected result.