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
This is sample input:
I already have a date table and the relationship created like below:
One is active with the Created Date.
Another is inactive with the closed date.
Hi Anonymous ,
Use below measure and you don't need the inactive relationship and USERELATIONSHIP() function.
Measure = CALCULATE(DISTINCTCOUNT('Table'[WORKITEM]),FILTER('Table',YEAR('Table'[CLOSEDATE])=SELECTEDVALUE('CALENDAR'[Date].[Year])&&MONTH('Table'[CLOSEDATE])=SELECTEDVALUE('CALENDAR'[Date].[MonthNo])))
Best Regards,
Jay
Hi Jay,
I'm not sure what is the reason but when I'm dragging fileds from my main table, all the values in the common created date table vanishes. Can' understand the reason as the relationship is also there.
P.S : I've created the measure as suggested. Now stuck on how to use it with my common date table.
Anonymous Also, can you please confirm what this Measure value is? Is it closed tickets or what?
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
Thanks my issue was resolved by using the common time table and the measure.
I created a calculated column for month year number and that resolved my issue.
Regards,
Himanshu