Forum Discussion
Anonymous
4 years agoNot 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 columns
Anonymous wrap your measures with:
If(HASONEVALUE('Table'[Code_Article], [Measure]).
It will blank the totals
2 Replies
- SpartaBI
Community Champion
Anonymous wrap your measures with:
If(HASONEVALUE('Table'[Code_Article], [Measure]).
It will blank the totals
- AnonymousNot applicable
Thanks alot it work perfectly 🙂