Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
RomainBSNP
Frequent Visitor

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 :

RomainBSNP_0-1707475721953.png

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

 

6 REPLIES 6
RomainBSNP
Frequent Visitor

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

RomainBSNP_0-1707477194880.png

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 ? 

@RomainBSNP 

PijushRoy_0-1707477918200.png

After BLANK(),SUM(your column))

 




Did I answer your question? Mark my post as a solution!
Appreciate your Like/Kudos

Proud to be a Super User!





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?




Did I answer your question? Mark my post as a solution!
Appreciate your Like/Kudos

Proud to be a Super User!





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

 

PijushRoy
Super User
Super User

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




Did I answer your question? Mark my post as a solution!
Appreciate your Like/Kudos

Proud to be a Super User!





Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.