Forum Discussion
Post PartisanInclude columns with different values in the same matrix
Hi Avivek
Here I have some advice.
Due to I don't know the data model of your tables, I build two sample tables to have a test.
Consignment Table:
Loaner Table:
Use unpivot and add index in two tables:
Result:
Add two calculated columns in two new tables and build matrix(Trun off the word wrap in column headers and reduce the row header of Loaner to 0).
Column = RANKX(FILTER(Consignment,Consignment[Attribute]=EARLIER(Consignment[Attribute])),Consignment[Index],,ASC)Column = RANKX(FILTER(Loaner,Loaner[Attribute]=EARLIER(Loaner[Attribute])),Loaner[Index],,ASC)Result:
If this reply still couldn't help you solve your problem please provide a sample pbix file by your OneDrive for business which has the same date models like yours.
You can download the pbix file from this link: Include columns with different values in the same matrix
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Post PartisanThe relations are already created, please find the image below
The table consignment has the columns Completed,last 2 months, proj, total proj, similarly we have same columns for loaner as well and so on.
Is it possible or is there some function by which I can get this.
Hi Avivek
Here I have some advice.
Due to I don't know the data model of your tables, I build two sample tables to have a test.
Consignment Table:
Loaner Table:
Use unpivot and add index in two tables:
Result:
Add two calculated columns in two new tables and build matrix(Trun off the word wrap in column headers and reduce the row header of Loaner to 0).
Column = RANKX(FILTER(Consignment,Consignment[Attribute]=EARLIER(Consignment[Attribute])),Consignment[Index],,ASC)Column = RANKX(FILTER(Loaner,Loaner[Attribute]=EARLIER(Loaner[Attribute])),Loaner[Index],,ASC)
Result:
If this reply still couldn't help you solve your problem please provide a sample pbix file by your OneDrive for business which has the same date models like yours.
You can download the pbix file from this link: Include columns with different values in the same matrix
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.