Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Exclude null date only when 'between' range is selected

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'. No...
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • bolfri's avatar
    bolfri
    2 years ago
    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:

     

bolfri's avatar
bolfri
Solution Sage
2 years ago

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's avatar
Anonymous
Not applicable
2 years ago

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

  • bolfri's avatar
    bolfri
    Solution Sage
    2 years ago
    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's avatar
      Anonymous
      Not applicable
      2 years ago

      Wish I could accept it a million times, Thank youuu

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      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 🤐