dynamic measures with multiple slicers

[RCSmart01]

For my issue i am having issues trying to do dynamic measures with multiple slicers.  I can do a dynamic measure with one slicer but i am having issues trying to do multiple slicers that work together.  The example is i have three slicers as a drop down and from the data that is selected within that slicer will show what measure to do for the graph. Right now for the single slicer i have the user select the single option and from that data the graph shows the measure properly. Below is the DAX i am using for the single select slicer.

Measure = switch(FIRSTNONBLANK(Table1[Column2],Table1[Column2]), "gross",SUM(Table2[Oil]), "Water", SUM(Table2[Water]), "Gas", SUM(Table2[Gas]))

Now how can i use this to do multiple slicers or a dax that will allow multiple slicers. Any help will be helpful and appreciated.

[v-chuncz-msft · Accepted solution]

@RCSmart01,

You may refer to the post below that uses expression TRUE ().

https://community.powerbi.com/t5/Desktop/Dynamic-Status-Based-on-Multiple-Date-Columns/m-p/234009#M1...