Clustered column chart for count of dates visualization in PowerBI

[Prath]

I am trying to create a report with months in X-axis and count of tickets created/closed on Y-axis from the data shown below. Based on what field I use in X-axis, I am getting different results but all incorrect. My expected result would have created=1/closed=3 in the month of December for reference.

Please help me understand what I am missing and how to achieve it.

X-axis with months of createddateX-axis with months of closeddateX-axis with months from separate tableData

[Prath]

@Icey  Thanks for your help. That solved it and learned something new today 😊

[Icey · Accepted solution]

Hi @Prath ,

Try this:

1. Create relationships between the two tables. Both "cross filter direction" are "Single".

2. Create measures.

Count of CreatedDate = COUNT('Table'[CreatedDate])

Count of ClosedDate =
CALCULATE (
    COUNT ( 'Table'[ClosedDate] ),
    USERELATIONSHIP ( 'Calendar'[Date], 'Table'[ClosedDate] )
)

3. Create a visual.

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.