Forum Discussion
Conditional filter
Hello 🙂 I have a filter (slicer) on my report for the expected delivery date but in a table we show the desired del. date too. Now I have the question wether it is possible to filter the e...
you could try something like this. But i am not sure it would work for all your scenarior.
Create measure that is like a switch.
Check Planned Date =
IF (
SUM ( Years[Actual Year] ) = SUM ( Years[Expected Year] ),
1,
0
)
IF (
SUM ( Years[Actual Year] ) = SUM ( Years[Expected Year] ),
1,
0
)
then in the filter pane set it to 1
then it will only return rows where the planned date = actual date, this assumes you always have both dates populated and you only ever want to return it where it equals each other. See pbix attached