Question about configuring multiple slicers and multiple DAX Switch statements
To all; I have a real world use case where I'm asked to take multiple slicers, set up as toggles, i.e. - all data is numeric, could be expressed as text for display (not actual DAX code) slicers: Average/Total "Average" = DIVIDE(<data> ,SUM(weeks)) "Total "= SUM(<data>) Dollars/Units "Dollars" = SUM(<data>) "Units" = SUM(<data>) CPIU/ROI "CPIU" = ( return - cost) / units "ROI" = ( Return - cost) The basic toggles work well, independently, but my use case needs them to 'nest' or 'cascade' the slicer slections and related value measures, so that data ex. "Spend" could be filtered by *Both* Dollars/Units and then Average/Total The data model is enormous, and I have little control over import of data not included in the original model. Any advice, suggestions or reasonably effective magic spells would be deeply appreciated Thank You ! Joe
