Forum Discussion

vishnusingh's avatar
vishnusingh
Frequent Visitor
4 years ago

Checkbox for BLANK Date

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

 

 

4 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

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

  • v-easonf-msft's avatar
    v-easonf-msft
    Icon for Community Support rankCommunity Support
    4 years ago

    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

  • technolog's avatar
    technolog
    Icon for Super User rankSuper User
    2 years ago

    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.