Forum Discussion
Non Dev Chart
Hi Anonymous ,
Yes, the measure counts the closed tickets. Because there an active relationship between date and create date.
Not very clear about your data model, I used date hierarchy Year and Month as axis.
I'll share my sample data with you. please check the attached file.
Best Regards,
Jay
Anonymous , Create measures.
Measure you create will have a filter on the created date and that is active.
Use userelationship(Table[Closed_date], Date[Date]) In calculates to use close date as the date.
In the date table have month year and plot measure against the month year of date table.
Refer to Hire and Termination in my blog.
amitchandak can you please help in the measure creation.
As per my understanding, i'll be needing 2 measures, one for Created Date and other one for Closed date but i'm not able to get the correct result.
Kindly advice what measures to use.
When using the month year from my date table it is not showing the months when the relationship is active. Also, when i make it inactive it displays data month wise but it seems incorrect.
this is when relationship is inactive: