Remove Unwanted rows from Matrix visual

[ritika3560]

I'm trying to display certain hierarchy in the matrix like : in matrix row field we have style(table a) followed by material code(table b) followed by purchase order((table b) followed by document number(table c) and in the value field we have table a's qty column, table b's qty column, table c's qty column. What is happening right now is, it is showing all of the material code under style irrespective of the value available in Table b quantity and Table c quantity. what I want is to show the rows with the values available in table a,b,and c's quantity column. and also if I apply filter value is not blank from filter pane on table b's qty and table c's qty, it shows visual has exceeded available resources. Kindly help me out in achieve the desired result, that is no such rows which don't have value in table b's qty and table c's qty.
attaching expanded matrix visual in excel for your reference.The rows highlighted in red shouldn't be there in the matrix itself 

[v-mengmli-msft]

Hi @ritika3560 ,

According to your description, do you want to hide the rows where both Bqty and Cqty are empty? If I understand correctly, you can try to create a measure.

tag = IF(ISBLANK(MAX('TableB'[B qty]))&&ISBLANK(MAX(TableC[C qty])),1,0)

Then filter the measure value to 0 in the Filter and adjust the column width to hide the tag column.

——————————————————————————————————————————————————

If my answer helps you solve the problem, please accept my answer as a solution and let it be seen by more people in need.

Best regards,

Mengmeng Li

[ritika3560]

Hi Mengmeng Li,

I have tried this approach as well but no change to the matrix 

[v-mengmli-msft]

Hi @ritika3560 ,

I hope I'm not disturbing you, how is the situation now? Feel free to contact me.

Best regards,

Mengmeng Li

[v-mengmli-msft]

Hi @ritika3560 ,

Could you please provide sample data and pbix file (exclude private data)? That will help me provide solutions.

Best regards,

Mengmeng Li