According to your description, you want to get the count of ID in which the one date column of a sale is not equal to BLANK() and another date column less than the date selected on a slicer, right? I think you can create a calendar table and a new measure to achieve your requirement, you can follow my steps:
- Create a calendar table:
Date = CALENDARAUTO()
- Create a measure like this:
Count of fitered ID =
- Then you can create a date slicer to place the date column in the newly created table and a card chart to place the measure like this:
You can download my test pbix file below
Thank you very much!
Community Support Team _Robert Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.