Forum Discussion
Date Slicer issue
Hi I have a dashboard which includes office locations, number of Live records (Count (distinct), Number of Blank Reviews based on null entries within date column - Measure1 = COUNTROWS ( 'Sheet1'...
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