Exclude null date only when 'between' range is selected

[Anonymous]

I have a table similar to this

and a date slicer 

What I want is that when a date slicer is applied like in this case the table should display only two rows '23 Feb' and '26 Feb'. Not the other two rows where the started at is null. However when no date filter is applied the table should be the complete table including all the null dates like this 

Here is the pbix file 

https://we.tl/t-9bANgKt2l4

[bolfri]

Hi,

you can use https://wetransfer.com/ and share a link with pbix file. 🙂 It will be easier to help you with this challenge.

[Anonymous]

Thank you so much, I have updated the post with the pbix file 

[bolfri · Accepted solution]

IsFiltered = IF(ISFILTERED('Table'[Started at]) && ISBLANK(SELECTEDVALUE('Table'[Started at])),0,1)

Create a measure like this and apply filter on the table to see only values where IsFiltered is 1.

When no filters:

With filters:

[Anonymous]

One more thing if you could help. I want the scorecards to be filtered as well , so in this case the value should show 2 instead of 4 

I tried applying the filter on this scorecard but it remains static and doesn't change 🤐

[Anonymous]

Wish I could accept it a million times, Thank youuu