Creation and closed ticket count

Hi Pavani,

I am not sure how you are getting these count. But the ideal way to get right numbers is

1. Create separate date table and use date from this table in the visual.

2. Create one active and inactive relationship with Created Date & Closed Date.

3. Use "USE Relationshi" funciton to get right count for inactive relationship date.

Please refer below link

https://learn.microsoft.com/en-us/dax/userelationship-function-dax

Appreciate a Kudos! ‌‌
If this helps and resolves the issue, please mark it as a Solution! ‌‌

Regards,
N V Durga Prasad