PowerPivot Suppress Rows in Pivot That Are Blank Or Zero

[goss]

Hi all,

Using Excel 2010.

How can I write a Measure to suppress a Blank or Zero Row?
Currently, I have 5 Values in the Pivot.
Sometimes, the first 4 Values are Blank but the 5th always has a value

How can I override this so that the first Value is dominant and determines if a Row should be displayed or not, regardless of what is going on with the 5th Value?

Thanks
w

 

[goss]

For the moment, I used the value filter in each Pivot Table to suppress the rows that are 0 or blank in the first value field.
Still, I think there must be a way to do this with Meausres.

Solved for the time being.
Thanks
w