Matrix table

[prabhuk]

Hello,

I have 3 tables namely Op Stk, Purchase, Sales and i want to create summary table as below.

When i use matrix table each measurs(Op Stck, Purchase etc..) reflect in seperate column but i need all the materix in one column ("Value").

Particulars	Value
Op Stk (From Op Stk table)	1000
Purchsaes ( From Purchase table)	2000
Sales (From Sales table)	2500
Cl Stk (To be calculated from the above)	500

[v-henryk-mstf]

Hi @prabhuk ,

According to your request, I simply did the following test: created 3 tables, namely OP, STK, purchase, sales. On this basis, I created a new table structure and data, as shown in the figure. Finally, the ID column is added to rows and the Data column is added to values by matrix visual, and the correct results are obtained. If there are problems, please provide comprehensive table data and information, so that I can do more detailed tests to solve your problems.

Here is the sample pbix file.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[MFelix · Accepted solution]

Hi @prabhuk ,

On the matrix options search for the option show on rows this is on the Values part of the options.