Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I have below Matrix and I want to add "Net Profit" under Main Account Group (Row field), Net Profilt = Revenue - Material Cost - Operational Expenses.
Could someone teach me how to do this please?
Thanks
HI, @Yindiao
After my research, it does not support that add customized Rows or columns in the matrix for now.
But you can get the same effect by this way:
Add a measure for every column like these
Current Net Profilt = CALCULATE(SUM(Table1[Current]),Table1[Main Group]="1000")-CALCULATE(SUM(Table1[Current]),Table1[Main Group]="1900")-CALCULATE(SUM(Table1[Current]),Table1[Main Group]="2000")
6M Net Profilt = CALCULATE(SUM(Table1[6M]),Table1[Main Group]="1000")-CALCULATE(SUM(Table1[6M]),Table1[Main Group]="1900")-CALCULATE(SUM(Table1[6M]),Table1[Main Group]="2000")
then disable the Row subtotals and drag them into Card visual or other visual like this
They can also influence each other.
Best Regards,
Lin
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
100 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |