Forum Discussion

maruthi's avatar
maruthi
Frequent Visitor
8 years ago
Solved

Display dynamic measures based on slicer/filter seelctions

Dear All,   I have bar graph where it should display different measures based on filter/slicer selection.    Data model looks like:   1. Dimension_Region 2. Fact_sales   Slicer Data which co...
  • vega's avatar
    8 years ago

    You'd want to do something like this:

     

    Measure :=
    IF(
        ISFILTERED(Dimension_Region),
        [Measure2],
        [Measure1]
    )

    Where Dimension_Region is replaced with the column that the slicer is getting its data.