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

Score big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount

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
August Power BI Update Carousel

Power BI Monthly Update - August 2025

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

August 2025 community update carousel

Fabric Community Update - August 2025

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