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 to do this please?

 

Thanks

2 Replies

  • 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