Matrix Table

Question

Hi.&nbsp;Probably there is a solution, but I can't find anything. I want to keep only selected values in Matrix Table.&nbsp;So I have got something like that.&nbsp;Column A | Column B | Column CX&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;| Y&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;| X+YX&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;| y1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;| X + y1X&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;| y2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;| X + y2&nbsp;Column C is a measure A + C of course.&nbsp;And I want something like that.&nbsp;Column A | Column B | Column CX&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;| Y&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;| X+YX&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;| y1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;|&nbsp;X&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;| y2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;|&nbsp;&nbsp;So blank cells in Columns C (only X+Y will stary).&nbsp;How can I do something like that?

amitchandak · Answer

jdmbkj , not very clear but this has to do using a measure, not using a selection 
&nbsp;
calculate(Sum(Table[Col1]) + Sum(Table[Col3]) , filter(Table, Table[Col2]&nbsp; =20 ) )

v-kkf-msft · Answer

Hi&nbsp;jdmbkj&nbsp;,
&nbsp;
Not very clear, in what context are you trying to achieve that output?
How do you want to present the three columns in the matrix?
&nbsp;
Best Regards,Winniz

Forum Discussion

Matrix Table - keeping selected cells

2 Replies

Related content

Keeping Power BI Matrix Expanded

Keep visual selections when publishing

OneLake storage keeps growing?

Datasets keep losing gateways