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.
Hi,
I have a fact table which contais a category variable with possible values as below
- Basic
- Inter
- Advanced
- Misc
User wants a filter to say wether to Include OR Exclude the "Misc" category in the report.
The visual should be through a filter with two options Include and Exclude (Through standard slicer or through chiclet slicer).
Easier option is to include all the 4 values and ask the user to select all OR exclude MISC option only. But looking for a simple interface where user can do this with one click option.
Hi @natg,
If I understand you correctly, you can firstly add a filter with two options Include and Exclude on your report, then try using the formula below to create a measure to calculate values to Include OR Exclude the "Misc" category.
Measure = IF ( HASONEVALUE ( Table1[Option] ), IF ( VALUES ( Table1[Option] ) = "Exclude", CALCULATE ( SUM ( Table2[Value] ), FILTER ( ALL ( Table2 ), Table2[Category ] <> "Misc" ) ), SUM ( Table2[Value] ) ), SUM ( Table2[Value] ) )
Regards
Thnaks for the solution workaround @v-ljerr-msft
Will try this and revert back.
Since this filter is kind of a global filter to be applied to 20+ metrices shown in the dashboard, thinking of implementing through joins with additional views in the model so that the existing calculations remain that way.
Is my understaning correct that I need to use the condional logic in all the measures that are impacted by the filter on category column.
Hi @natg,
Is my understaning correct that I need to use the condional logic in all the measures that are impacted by the filter on category column.
Yes, that's correct.
Since this filter is kind of a global filter to be applied to 20+ metrices shown in the dashboard, thinking of implementing through joins with additional views in the model so that the existing calculations remain that way.
It seems to be a better solution.
Regards
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 |
---|---|
105 | |
94 | |
75 | |
63 | |
62 |
User | Count |
---|---|
137 | |
105 | |
104 | |
80 | |
63 |