Clustered Column Chart Visual

[Anonymous]

Hi, I have a clustered column chart visual to show the comparison between the number of due tasks and number of completed tasks per month. There should only be 3 completed task in May however this is not the case. Please help? 

[v-yingjl · Accepted solution]

Hi @Anonymous ,

You can create a measure to count:

Count of Completed Month = 
CALCULATE (
    COUNT ( 'Table'[Completed Month] ),
    FILTER ( 'Table', 'Table'[Due Month] = 'Table'[Completed Month] )
)

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin]

Show your data model, especially how you connect to your Calendar table (or tables)