Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello,
I would like to ask how to create a measure like this. If column A="Yes', then measure [sum1], else [sum2]?
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.
Yes it didn't help. Because with condition Yes I expected to see result of sum1 but output is sum2.
User | Count |
---|---|
97 | |
88 | |
76 | |
70 | |
63 |
User | Count |
---|---|
112 | |
96 | |
95 | |
67 | |
65 |