- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Count of of Date Date Columns that Filters for Date
Hello! I have a table, 'Driver', with a column, [Termination Date]. I am trying to write a measure that counts how many fields in the column have dates, and have that number be able to be filtered by what date is in the field. I have been able to write a measure that returns the count but it does not respond to any of my date slicers I have on the page. Current DAX expression that I have applied is:
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot). Leave out anything not related to the issue.
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.
https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

So here is an example of the table I am working with:
Driver_Name | Termination_Date |
Jim Smith | null |
Jane Smith | null |
John Jones | 5/20/2023 |
William Orange | 7/15/2023 |
Bill James | null |
Hoped for output would be it only counts the two that has dates next to it, and that it will respond to the date slicers I have already put onto that page. It should return a count of two if I have it filtered for May through July, only a one if filtered for just July, and a zero if filtered for August. I hope that made sense, and thank you for responding either way.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Add a calendar tabe to your data model, apply the filter to that table, and have a card visual that counts the number of rows in your fact table.

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
08-20-2024 06:48 PM | |||
08-08-2024 10:34 PM | |||
02-01-2024 06:02 PM | |||
06-12-2024 06:52 AM | |||
01-19-2024 07:55 AM |
User | Count |
---|---|
141 | |
110 | |
81 | |
61 | |
46 |