Count with selection

[Anonymous]

Hi All,

I have source data like this: 

I need to count the infected and recovered results of each user per year and month. If infected and recovered are in the same month and year then infected is not counted (Infected : 0, recovered: 1) so the result will appear as follows:

How can I achieve this? Please help.  

Thank you

[AllisonKennedy · Accepted solution]

Okay, here's the sample file (below signature). 

A few DAX measures to work it out. 

[Anonymous]

Thank you so much @AllisonKennedy  for your help. This should work and really appreciate your time and help.

[AllisonKennedy]

You're welcome - glad you found it useful. 😀

[AllisonKennedy]

@Anonymous  I will make a sample report for you now - in future if you could PASTE the TABLE (not a screenshot of table) into your post this process is much quicker. 😀

[Anonymous]

Thank you for the suggestions.