Checkbox for BLANK Date

[vishnusingh]

Hi Experts,

We have a requirement to create a filter(Slicer) like the below image that we have created but I am unable make 'Include BLANK Date' functional.

The requirement is like when we Select(checkbox) of 'Include BLANK Date', it should show us the list and update the count.

Expectations -

• Select(checkbox) of 'Include BLANK Date' (With Network Device Filter)
  • List CIs to show - 137
  • Count - 137
• Unselect(checkbox) of 'Include BLANK Date' (With Network Device Filter)
  • List CIs to show - 6
  • Count - 6

I tried below DAX but not working.

Last Scan is Blank =
VAR _Checkbox =
SELECTEDVALUE ( 'Last Scan is NULL'[Include NULL Date] )
VAR _YES =
CALCULATE (
FILTER (
'Conslidate Data',
ISBLANK('Conslidate Data'[Last Update Success])
),
'Conslidate Data'[count]
)
RETURN
IF (
HASONEFILTER ( 'Last Scan is NULL'[Include NULL Date] ),
IF ( _Checkbox = "Include BLANK Date", _YES ),
""
)

[technolog]

I hope this message finds you well. I've noticed that this solution remain unresolved. If any of you have managed to find a resolution to the issue, I kindly request that you share your solution for the benefit of the entire community. Alternatively, if you're still facing challenges, please do let us know as well.

Your insights and updates will greatly assist others who might be encountering the same challenge.

[v-easonf-msft]

Hi, @vishnusingh 

I doubt that capturing the checked state of that option in slicer via dax is not supported.

Best Regards,
Community Support Team _ Eason

[vishnusingh]

any assistance on this?

[sarabaia]

Did you manage to solve this ? I have a similar request