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

vanessafvg's avatar
vanessafvg
Community Champion
5 years ago

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

Anonymous's avatar
Anonymous
Not applicable
5 years ago

This is the expected chart:

 

 

I'm able to make them seperately but not together.

 

 

  • vanessafvg's avatar
    vanessafvg
    Community Champion
    5 years ago

    can you provide some sample data (in text form)

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      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.

       

       

      • 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