Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Non Dev Chart

Hi All,   I have a situation here and its confusing for me.   I have two columns in my report i.e Created Date and Closed Date and I have calculated column where i have the distinct count of the ...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    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's avatar
Anonymous
Not applicable
5 years ago

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

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Anonymous Also, can you please confirm what this Measure value is? Is it closed tickets or what?

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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's avatar
    Anonymous
    Not applicable
    5 years ago

    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