Forum Discussion

Yindiao's avatar
Yindiao
Frequent Visitor
7 years ago

Need Help - Customized Row in Matrix

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 ...
v-lili6-msft's avatar
v-lili6-msft
Community Support
7 years ago

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