The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
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 🙂
User | Count |
---|---|
65 | |
60 | |
55 | |
54 | |
31 |
User | Count |
---|---|
180 | |
88 | |
70 | |
46 | |
46 |