compare values from a matrix

Hello everyone,

My question is rather basic for those who master Power BI (this is not my case yet 😞) :

I have a simplified dataset with a number of an agent and a date on wich a certain task was performed :

I also have a table of dates to facilitate the management of dates:

-There is a relationship between two tables with the 'date' field-

I need to check if each agent performs a task at least once a month. This means that in March an agent must reach the accumulation of 3 tasks not to be 'late'.

So far I managed to create a sum of the tasks :

... and then make the cumulation :

cum_tache = CALCULATE('my_table'[sum_tache], DATESYTD(('my_calendar'[date])))

 

...which gives the following result on the visual matrix:

 

Q1: I would like the date to be displayed in month format, but when I choose the 'month' field from my 'date' table, the cumulation of values does not work.

 

Last problem: I need my matrix to display in a binary way if the cumulation for a given month is equal to the month, e.g. for ag_3
For January: he performed 1 tasks so we display "1"
For February: its cumulation is equal always at 1 so we display "0"
For March: it has performed 1 task - its cumulation is at 2 - so we display "0" (it should be at 3)

 

Q2 : So my question is - is it possible to compare the cumulative values with an int value that represents the month concerned?

 

Thank you in advance for your help.

Best regards,

 

Mag Cle