Count how many times a measure is equal to 1

[mtrevisiol]

Hi everyone. I've got this table:

the only column is the Month one, the others are measures. The last column in the table, "success/failure", is a measure calculated as 

var perc = DIVIDE(
         [Sales],

         [Budget],

         BLANK())

RETURN IF(perc>1, 1, 0),BLANK())

How can I count the number of months in which succes/failure is equal to 1? The result would be 5.

Thank you.

[amitchandak · Accepted solution]

@mtrevisiol , Create measure like

sumx(values(Table[Mese]), [success/failure])

If you want to have a formula of [success/failure] in that place make sure to use calculate,

calculate(<formula>)

[mtrevisiol]

Thank you so much @amitchandak