Remove blank values in matrix for both columns and new total calculated

[Anonymous]

Hi, 

I would like to know how to remove blank values in a matrix for both columns.  There are products that only Company X have, products that only Company Y have and products that both companies have.  How I know if the products have the same products is if the measure does not pull a blank value.  (for context, would like to have this same matrix for 5 company comaprison and don't want to have to find the products that are the same throughout all 5 companies).  I tried the visualization tool to filter out "is blank" but it doesn't work when there is a value for Company Y but a blank for Company X for a particular product (aka for a row). 

Please see screenshots below that could help with context.  Really appreciate the help! 

rows that I want removed completely and not counted in the total. New total should be lower as a result.

Thanks in advance!

[v-yuta-msft]

@Anonymous ,

The info you give is not complete. Could you please share some sample data and clarify more details about your expected result?

Regards,

Jimmy Tao

[Anonymous]

Hi @Anonymous ,

Do you mean if company x or company z is blank, then remove the row?

If yes, you can change the measure for company x and company z to

company x = if company x >0 and company z > 0,company x,blank()

company z = if company x > 0 and company z >0, company z, blank()

Then put these two new measures into the table, I think that's what you want.

Aiolos Zhao