How to hide some rows values in a Matrix

[RomainBSNP]

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 Overriden_value, but don't want the detail for every sub value of CS.

Regards

[RomainBSNP]

Hello and thank you for a quick answer ! Sorry for my lack of knowledge, but I'm not getting the end of the measure :

I tried to set the Overriden valeur as last parameter of the measure, but it is not working. Can you explain a little bit more so I understand this part ? 

[PijushRoy]

@RomainBSNP 

After BLANK(),SUM(your column))

[RomainBSNP]

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 !

[PijushRoy]

@RomainBSNP 
Is it working now?

[RomainBSNP]

Seems like we replied at the same time approximatively. See my post above :).

[PijushRoy]

Hi @RomainBSNP 

Create a measure like (Item is the column which holds data line ACTUAL_PICES ect)

Measure = VAR _Item = SELECTEDVALUE(Table[Item])
RETURN
IF(
_Item IN {"ACTUAL_PICES","----","----",so on},BLANK(),YourMeasure or Value COl)

Let me know if that works for you

If your requirement is solved, please mark THIS ANSWER as SOLUTION ✔️ and help other users find the solution quickly. Please hit the LIKE 👍 button if this comment helps you.

Thanks
Pijush
Linkedin