Hi all,
I think i have a simple question but cant find a way to do it in Powerbi.
Please see simplified table below.
If i filter 0 from the matrix, the top row dissapears as 1 and -1 = 0.
How can i keep this row and remove column E in this case.
I somehow need a DAX formula that respects the context of sum per column and row?
many thanks in advance!
Hi @Joe_100 ,
I am afraid that there is no elegant way to implement it. Anyway, you can use the following method as a workaround:
1.Create a simple table.
2.Select a Matrix visual. Move the Column2 to Rows, move the Column1 to Columns, and move the value to Values.
3.Create a Sum of Value Measure.
4.The matrix remove the column E.
5.If the above one can't help you, could you please provide more raw data(exclude sensitive data) with Text format and your expected result with backend logic and special examples? It would be helpful to find out the solution.
Looking forward to your replay.
Best Regards,
Wisdom Wu
Hi @Joe_100 ,
I am afraid that there is no elegant way to implement it. Anyway, you can use the following method as a workaround:
1.Create a simple table.
2.Select a Matrix visual. Move the Column2 to Rows, move the Column1 to Columns, and move the value to Values.
3.Create a Sum of Value Measure.
4.The matrix remove the column E.
5.If the above one can't help you, could you please provide more raw data(exclude sensitive data) with Text format and your expected result with backend logic and special examples? It would be helpful to find out the solution.
Looking forward to your replay.
Best Regards,
Wisdom Wu
Helpful resources
Power BI Monthly Update - November 2025
Check out the November 2025 Power BI update to learn about new features.
Fabric Data Days
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
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.
