Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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.
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.
Will this also work on a table/matrix visual?
Hi vega,
I tried but no luck 😞
Above is the error I got it.
You are missing a closing parenthesis after [regions]
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
97 | |
78 | |
63 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |