Removing blank rows from matrix visual with ISINSCOPE measures?

[murphm6]

Hi all,

I have a matrix visual that has 3 rows of hierarchy (customer, product, location) and values pulling from a few different tables. Some of the values are measures that utilize the ISINSCOPE() function to only show values at a certain level. 

I've tried adding a visual level filter for only showing rows with order values that are not blank or 0. I've also tried creating custom column flags to only show rows that have been flagged for having order values greater than 0 and not blank. 

How can I get rid of these rows that have blank values for Average, Orders, Fcst Avg, etc...

[TomMartens]

Hey @murphm6 ,

to me it seems that the two highlighted columns are also measure values, if this is the case then it will not be possible.
If both columns are not values but instead part of th row headers check the setting, maybe one column has the Show items with no data has checked:

Hopefully, this helps to tackle your challenge.

Regards,

Tom