[Need Help ] get the sum of three query filtered by date and a boolean value

[Maxime_leroy]

hello ,  i'm new in powerbi and i'm stuck on basic dax query 😕 . I have three actions with a limit date and a state (true if it's done and false if it's not) , i would like to get the number of late actions so it need to be the sum of action 1 , 2 and 3 where the state is false and the date limit is < to the day.

in power apps i get the value with :
((state action 1 = false && 'date action 1' - Today() < 0 ) + (state action 2 = false && 'date action 2' - Today() < 0 ) ) + (state action 3 = false && 'date action 3' - Today() < 0 ) 

i've try thing like : 

action en retard = SUM(Filter(QualityAlerts,QualityAlerts[state action 1] = false && QualityAlerts[Date Action 1] - TODAY() < 0)

but it tell me that sum fonction only accept to refer to a colum as argument .
if anyone could give me some tips it will save me ^^ 

[amitchandak]

@Maxime_leroy ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[Maxime_leroy]

here the numbre to display will be 5