Hide rows based on specific values

[YarinInbar]

I have a sheet with a pivot table that shows inventory of items in our stores.

Item name	STORE A (WAREHOUSE)	STORE B	STORE C	STORE D
Item 1	-	0	1	5
item 2	25	1	5	9
item 3	40	1	0	0
item 4	-	0	0	0

Dimensions: item description
Column: Store name
Measures: Inventory quantity 

I defined a set expression that filter only items from specific brand, and only specific stores that I want to show.

The only thing remains is that I want to hide items that have no inventory quantity in store A which is our warehouse. 

how can I do that?

[Or]

By using a different measure, e.g.

[Inventory Quantity] * If({< [Store Name] = {'STORE A'}>} [Inventory Quantity]>0,1)

And then hiding 0/null rows.

If Store A is guaranteed to always be the first store, you could pull this value using the First() function instead.

You could use a similar method with a calculated dimension if you prefer, I believe, but I think in that scenario it'd be less efficient.