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.
