Order for Matrix in same table

[eduardosilvin3]

Hello all, I am wondering how could I order my matrix, I have a table with costs and revenues, so I do not want to duplicate the table becaus the real life has a lot of registers, so I think a mesure can help me to add in one column all the numbers by costs and revenues.

I need:

I have: 

Table: 

[eduardosilvin3]

Not 100% what I expected, but totally gave me the dax functions I needed to get my code. Thanks!!!

[amitchandak · Accepted solution]

@eduardosilvin3 , You have to create a dimension with two column and one column will revenue and cost and another will have child revenue and child cost. Join this column with child revenue and child cost

dim=

Union (

Summarize(Table, Table[Revneue], Table[Child Revenue]) ,

Summarize(Table, Table[Cost], Table[Child Cost]) )

One join will be inactive that you can activate using userelationship in measure

sum(Table[Revenue]) + calculate( sum(Table[Revenue]), userelationship (Table[Child Cost], dim[Revenue Cost] ) )

example of userelationship

Power BI: HR Analytics - Employees as on Date : https://youtu.be/e6Y-l_JtCq4
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...
Power BI HR Active Employee Tenure Bucketing, and Hired, Terminated, and Active employees: https://youtu.be/fvgcx8QLqZU