Forum Discussion
Solved
Count between start and end date
I have a table as follows. I want to get a count of names between start and end date. the result is a table like figure 2. I have a datetable related to this table. When I do the measure, it is ju...
Hi joshcomputer1 ,
Your measure is correct however your datetable needs to be disconnected from your Test Table.
Since you have a relationship on the Start Date your data is filtered by the start date only so give you 6 as a result and not the expect outcome.
Check the image below and PBIX file attach:
Regards,
MFelix
Hi RoofTopNomad ,
In this case just try to add the metric on the table visualization filters and set the filter to is not blank. This should give you the expected result that is filtering the records based on the metric selection.
Of course! What an obvious solution! Thanks