Forum Discussion

michalintive's avatar
michalintive
Regular Visitor
9 years ago
Solved

Power BI subscrating Matrix view.

Hi all,   I need to create a new column with resoult of subsctracting two columns in Matrix view. I've tried to do it by guides in this community but I wasnt able to do it.   I need to do cal...
  • v-chuncz-msft's avatar
    v-chuncz-msft
    9 years ago

    michalintive,

     

    You may refer to the following measures.

    Revenue =
CALCULATE ( SUM ( Table1[Value] ), Table1[Cost_Center_2] = "Revenue" )

    Costs =
CALCULATE ( SUM ( Table1[Value] ), Table1[Cost_Center_2] = "B Project Costs" )

    X =
[Revenue] - [Costs]

    Percent =
DIVIDE ( [X], [Revenue] )
michalintive's avatar
michalintive
Regular Visitor
9 years ago

Hi all,

 

Thanks for all solutions. There is one more thing. Desktop PowerBI shows me now measures after each column:

Is there any way to show columns with measures only after Cost Center 2, in the way as below?

 

Much apriciate for your help!

michalintive's avatar
michalintive
Regular Visitor
9 years ago

Ok, problem solved, I hidden the columns :) Thank you all!!