Measure to filter column values >=1

[sindrekb]

I have a table showing inventory across three main categories all in separate columns. 

- Allocated to Demand

- Allocated to Saftety Stock

- Not Allocated

How can I create a measure for these categories, where if "Allocated to Demand" is selected, I only see the Items Allocated to Demand with quantities greater to or equal to 1? 

I note that due to the complexity of the structure in the actual report, I'd would ver much prefer to solve this with a measure in DAX rather than through Pivot/Unpivot in PowerQuery. 

Thank you. 

[sindrekb]

This works for the "Allocated to Demand" structure, but if possible, how can all categories be structured in one singular slicer, where if I select "Allocated to Demand", the table will show all items in Column "Allocated to Demand", greater than or equal to 1. And the same for "Allocated to Safety Stock" and "Not Allocated".

The snip below examplifies this visually, but note that this solution does not work in practice as the model I'm working with is quite complex. 

[ryan_mayu · Accepted solution]

@sindrekb 

pls try this

Measure = switch(true(),SELECTEDVALUE('Table (2)'[column])="Allocated to Demand" && sum('Table'[Allocated to Demand Stock])>=1,1,SELECTEDVALUE('Table (2)'[column])="Allocated to Safety Stock"&&sum('Table'[Allocated to Safety Stock])>=1,1,SELECTEDVALUE('Table (2)'[column])="Not Allocated"&&sum('Table'[Not Allocated])>=1,1)

pls see the attachment below

[ryan_mayu]

@sindrekb 

you can try to create a measure

Measure = if(sum('Table'[Allocated to Demand])>=1,1,0)

and add this measure to visual filter and set to 1