Forum Discussion
Date Slicer issue
The content below is a snapshot - in col.3 there are both dates and null values. I've managed to show a count of null values but it shows as the full amount. I want to be able to filter the date slicer to show dates prior to a particular date of choice by the user which also shows how many null values there are by Area.
HI Aj72,
Perhaps you can try to use the following measure formula to use allselected function to responded with filter effects and calculate the filtered blank row counts:
blankRows = COUNTROWS ( FILTER ( ALLSELECTED ( 'Sheet1' ), Sheet1[Next LM Review Date] = BLANK () ) )Managing “all” functions in DAX: ALL, ALLSELECTED, ALLNOBLANKROW, ALLEXCEPT - SQLBI
Regards,
Xiaoxin Sheng
Hi Anonymous I'm not sure if I have implemented it correctly, but it doesn't seem to have affected the number on my card visual 🤔
HI Aj72,
Can you please share some dummy data and paste here with table format? Then we can copy these data and improve to power bi to test coding formula.
Regards,
Xiaoxin Sheng