Forum Discussion
Help with error in row subtotals
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!
2 Replies
- amitchandak
Super User
- SantiNarvFrequent Visitor
Thanks so much!