Calculate measure that returns the same as a visual

[Veljanov]

I've a dataset similar to the one below. What I want to do is to create a mesure to calculate the number of projects that have more than 40% of it's rows as certified. 

I can accomplish this by making a mesure somthing like:

= CALCULATE ( COUNTROWS ( Data ), Data[Status] = "Certifierad" )/Countrows(Data)) and then putting my mesure and the Project column in 100% bar chart to see what projects have more than 40% certified rows. How to I do this in a mesure that returns the number of projects that I can use in a card visual?

Any help would be appricated! 😊😊

[Veljanov]

Learned something new, thank you! 👍

[Greg_Deckler · Accepted solution]

@Veljanov So typically something like:

Measure =
  VAR __Table = SUMMARIZE('Table',[Projects],"Percent",[Your measure])
RETURN
  COUNTROWS(FILTER(__Table,[Percent] > .4))