topic Re: Checkbox for BLANK Date in DAX Commands and Tips

Checkbox for BLANK Date

vishnusingh — Thu, 23 Jun 2022 13:11:36 GMT

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 ), "" )

Re: Checkbox for BLANK Date

vishnusingh — Fri, 24 Jun 2022 04:19:30 GMT

any assistance on this?

Re: Checkbox for BLANK Date

v-easonf-msft — Mon, 27 Jun 2022 08:09:30 GMT

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

Re: Checkbox for BLANK Date

Anonymous — Tue, 29 Aug 2023 09:29:00 GMT

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

Re: Checkbox for BLANK Date

technolog — Sun, 24 Sep 2023 14:44:00 GMT

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.