Matrix from different tables

Question

Hello Team,&nbsp;I want a summary table. I have values(Measures) in different tables which don't have any relationships. Only Year is common in all tables.&nbsp; SL% from one table, Total from raw data ETC...&nbsp;&nbsp;&nbsp;&nbsp;

mlsx4 · Answer

Hi&nbsp;Anonymous&nbsp;Do you have a Calendar Date? If you don't, create one and use year field to link both. Then include in your matrix year column from Calendar Date with your measures from each table

anonymous · Answer

I have a calendar table and also i linked it, but when I pull data it's not i the proper way. I just need year in the column&nbsp;&nbsp;

anonymous · Answer

Hi&nbsp;Anonymous&nbsp;,
&nbsp;
I found that your matrix also has row fields, and the row fields are related to your two measures?

Then your [total FTE] measure is all the same value, because your measure has no relationship with your row field, right? I don't know what your expected outcome will look like. If you can, please provide some dummy data, along with the desired result, and I'll try to help you achieve it.
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
Best Regards,
Stephen Tao
&nbsp;
If this post&nbsp;helps, then please consider&nbsp;Accept it as the solution&nbsp;to help the other members find it more quickly. &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;

Forum Discussion

Matrix from different tables

3 Replies

Related content

Matrix table

Matrix table

KPI level matrix table

Matrix table in Power bi

PowerBI - Matrix table, hide values used only for a visual calculation