Forum Discussion
Counting Rows By Date Column Where The Date Is Between A Specific Period
Hi FlyKick ,
If your X axis uses Tickets table's Date, you can create a measure and put it in Filter on this visual. Configure it as 1.
Measure = IF( MAX(Tickets[ClosedOnDateOnly])>=MIN('Date'[Date]) && MAX(Tickets[ClosedOnDateOnly])<=MAX('Date'[Date]),1,0)If your X axis uses Date table's Date, please try to delete the relationship between the date table and Tickets table.
If it doesn’t meet your requirement, could you please provide a mockup sample based on fake data?
It can help us reproduce your issue.
Please upload your files to OneDrive For Business and share the link here. Please don't contain any Confidential Information or Real data in your reply.
Best regards,
Community Support Team _ zhenbw
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Here is the result of adding the ALLEXCEPT function.
Hi FlyKick ,
If your X axis uses Tickets table's Date, you can create a measure and put it in Filter on this visual. Configure it as 1.
Measure =
IF(
MAX(Tickets[ClosedOnDateOnly])>=MIN('Date'[Date]) && MAX(Tickets[ClosedOnDateOnly])<=MAX('Date'[Date]),1,0)
If your X axis uses Date table's Date, please try to delete the relationship between the date table and Tickets table.
If it doesn’t meet your requirement, could you please provide a mockup sample based on fake data?
It can help us reproduce your issue.
Please upload your files to OneDrive For Business and share the link here. Please don't contain any Confidential Information or Real data in your reply.
Best regards,
Community Support Team _ zhenbw
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.