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 , Based on first look, I think you need a common date table and use userealtionship
Refer this blog
Hi amitchandak I have created the common date table and made the relationship also. one active with created date and one inactive with closed date. But confused how to proceed further.
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.
I have created the below two measures as suggested:
no of tickets by closed date = calculate(countrows('DAX Date Table'), userelationship('devops-query-spr2'[Closed Date],'DAX Date Table'[Date]))no of tickets by open date = calculate(countrows('DAX Date Table'))But where does my Non-Dev column goes? Sorry but I'm really confused here.How to check my Non-Dev ticket values. For closed and created.I have a calculated Column for non-Dev tickets which gives me 375 ticketsI'm still not able to show the closed and created together. Seperately they are working fine.