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!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
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
Solved! Go to Solution.
@Anonymous wrap your measures with:
If(HASONEVALUE('Table'[Code_Article], [Measure]).
It will blank the totals
@Anonymous wrap your measures with:
If(HASONEVALUE('Table'[Code_Article], [Measure]).
It will blank the totals
Thanks alot it work perfectly 🙂