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
Hi Himanshu do you have a date table?
what you need to do is create a date table, link both dates to that date table.
The first date will be the active relationship denoted by an unbroken line and you can create your measure easily by, by default this will be the first date you link
no of tickets by open date = calculate(countrows(tablename))
for the second date you link which will be the closed date the relationship to the date table will have a dotted line (please note the first date you link will be the active so link open date first)
the dotted line means this is an inactive relationship which you will need to activate with your measure.
no of tickets by closed date = calculate(countrows(tablename), userelationship(closeddate, date))
let me know if you have any questions
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.if you provide some sample date i think it will be much easier to demonstrate (make sure its in text format)
also can you show what result you arae expecting
This is the expected chart:
I'm able to make them seperately but not together.
can you provide some sample data (in text form)