Display dynamic measures based on slicer/filter seelctions

[maruthi]

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 comes from Dimension_Region and looks like below:

--> Select All

--> Asia

--> America

--> Europe

case-1: When "Select All" option selected in the filters/slicers, then it should display "Measure1".

case-2: When remaining option selected in the filters/slicers, then it should display "Measure2"

Please help me how to write DAX expression to implement? Thanks in advance.

Kind Regards,

Maruthi

[vega · Accepted solution]

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.

[aatiqjamuh]

Will this also work on a table/matrix visual?

[maruthi]

Hi vega,

I tried but no luck 😞

Above is the error I got it.

[vega]

You are missing a closing parenthesis after [regions]