Measure according to data table column value in Power BI

[Analitika]

Hello,

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

[rajulshah]

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]

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