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 -
When I move the date slicer to a particular reporting date, the Live records figure obviously changes but the Number of blanks in the date column doesn't - is there a way to have the date slicer affect the number of blank reviews based on null entries?
Relative newby so please be gentle 😉
5 Replies
Hi Aj72 ,
Can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.
How to Get Your Question Answered Quickly
Regards,
Xiaoxin Sheng
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 🤔
