Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Measure to filter column values >=1

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 ...
Need Help
Show and Tell
  • ryan_mayu's avatar
    ryan_mayu
    2 years ago

    Anonymous 

    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
Anonymous's avatar
Anonymous
Not applicable
2 years ago

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's avatar
    ryan_mayu
    Icon for Super User rankSuper User
    2 years ago

    Anonymous 

    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