Forum Discussion
How to hide some rows values in a Matrix
Hello everyone, Using PowerBI Desktop, I wonder If I can hide the values showing up in red area below : I want to keep the total of each CS Average theoretical_value_for_tr and Average of Ove...
Ok I understand now.
Unfortunately I have this error when trying to put the measure in the matrix :
Calculation error in measure 'Mesures'[measure]: Function 'CONTAINSROW' does not support comparing values of type Text with values of type Number.
The Overriden and theoretic value are set as decimal number, because I need to get the total of it at some point, so I cannot set it to Text.
I also tried :
Measure =
VAR _Item = SELECTEDVALUE(SHIPMENT_CFV[Overriden valeur])
RETURN
IF (
_Item IN {"MPL_BY_WIDTH", "PIECES"},
BLANK(),
SUMX(SHIPMENT_CFV, VALUE(SHIPMENT_CFV[Overriden valeur]))
)
Not working better..
If you have any more ideas, i'll take it !
RomainBSNP
Is it working now?Seems like we replied at the same time approximatively. See my post above :).