Forum Discussion
Ability to dynamically filter data based on conditions that is not mutually exclusive
Microsoft EmployeeHi 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. :smileyhappy:
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.
- v-ljerr-msft
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. :smileyhappy:
Regards