Forum Discussion
Order for Matrix in same table
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 , 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-trend/ba-p/882970
Power BI HR Active Employee Tenure Bucketing, and Hired, Terminated, and Active employees: https://youtu.be/fvgcx8QLqZU
2 Replies
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-trend/ba-p/882970
Power BI HR Active Employee Tenure Bucketing, and Hired, Terminated, and Active employees: https://youtu.be/fvgcx8QLqZUNot 100% what I expected, but totally gave me the dax functions I needed to get my code. Thanks!!!
