sum a measure with parameter

[Anonymous]

Hello PowerBi Community

I have a table of this kind :

Factory	Date	Result	Limit
A	01/01/2020	1.38	1.5
B	01/01/2020	1.75	1.5
A	01/02/2020	1.85	1.7
B	01/02/2020	1.52	1.7

I have a what if parameter to change the value of the limits. (By multiplicate the limits by the parameter)

Measure1 = sum(Table[Limit])*Parameter[Parameter value]

Then i have an another measure to calculate if the factory result is over the new limit :

Measure2 = [Measure1]-ABS(SUM(Table[Result]))

I want to count the number of sites that are over the limit

Measure3 = if([Mesure2]<0,1,0)

And now this is my problem i want to sum the Measure3 to know how many factory are over the limit. 
And use it in a graph with the date in x axis. 

Thank you for your help 🙂

[amitchandak · Accepted solution]

@Anonymous , try like

sumx(summarize(Table,Table[factory], "_1",[Measure3]),[_1])

sumx(filter(summarize(Table,Table[factory], "_1",[Measure3]),[_1]=1),[_1])

or

sumx(filter(summarize(Table,Table[factory], "_1",[Measure3]),[_1]=0),[_1])

[Anonymous]

This one perfectly works for me : 

sumx(filter(summarize(Table,Table[factory], "_1",[Measure3]),[_1]=1),[_1])

Thank you !