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

Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM. Register now.

Reply
Anonymous
Not applicable

Remove only 3 total columns in matrix

Hi guys 

I have a matrix that contains products code and measures that belong to these products however i want to remove 3 total column  from the matrix because it dosen't make a sense for some reasons, here is the screenshot I want to remove only the total of these columns (M_conversion,LY_QANT,YTD_QANT).

Only code_article is a colum, of the table and all of the rest are measures

how can i remove them? the 3 total columnspb.PNG

1 ACCEPTED SOLUTION
SpartaBI
Community Champion
Community Champion

@Anonymous wrap your measures with:

If(HASONEVALUE('Table'[Code_Article], [Measure]).

It will blank the totals

View solution in original post

2 REPLIES 2
SpartaBI
Community Champion
Community Champion

@Anonymous wrap your measures with:

If(HASONEVALUE('Table'[Code_Article], [Measure]).

It will blank the totals

Anonymous
Not applicable

Thanks alot it work perfectly 🙂 

Helpful resources

Announcements
October Power BI Update Carousel

Power BI Monthly Update - October 2025

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

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Kudoed Authors