Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi Power BI Community,
Please your kind help giving me a hint about how to author the following measure so it does not generate an error at the moment of enabling the row subtotals.
I am going to use the data below to explain what the problem is.
The measure I authored is this one: Measure=If(Values('Table'[Performance criteria])="%",10,20)
At the moment of including the data and the measure into a matrix (with row subtotals=disabled) there was no problem.
However, when enabling the row subtotals, the following error message popped up.
I am aware that the problem is the fact that the "Value" dax function in the measure is providing more than 1 value into the row subtotal cells within the matrix (% and ppk) and for that reason the error message pops up, but I have not being able to find other way to author that measure.
Thanks in advance for your help!
Solved! Go to Solution.
@SantiNarv , Try like
Measure=If(max('Table'[Performance criteria])="%",10,20)
Thanks so much!
@SantiNarv , Try like
Measure=If(max('Table'[Performance criteria])="%",10,20)
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
98 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |