Don't miss your chance to take exam DP-600 or DP-700 on us!
Request nowLearn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now
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:
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...
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.
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.
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
Check out the February 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 49 | |
| 40 | |
| 32 | |
| 14 | |
| 13 |
| User | Count |
|---|---|
| 85 | |
| 70 | |
| 37 | |
| 28 | |
| 27 |