Forum Discussion

Analitika's avatar
Analitika
Icon for Post Prodigy rankPost Prodigy
4 years ago

Measure according to data table column value in Power BI

Hello,

 

I would like to ask how to create a measure like this. If column A="Yes', then measure [sum1], else [sum2]?

Need Help

2 Replies

  • rajulshah's avatar
    rajulshah
    Icon for Resident Rockstar rankResident Rockstar
    4 years ago

    Hello Analitika ,

     

    You can create a measure as follows:

    Measure = IF (SELECTEDVALUE(Table[ColumnA])="Yes",[Sum1],[Sum2])


    Please let me know if this didn't help.

    • Analitika's avatar
      Analitika
      Icon for Post Prodigy rankPost Prodigy
      4 years ago

      Yes it didn't help. Because with condition Yes I expected to see result of sum1 but output is sum2.