DAX to count values that are 100% based on date profile

[Anonymous]

Hi,

Need help to create a DAX measure that counts all the values that are 100% for each specifc month. 

Below image as a guide. 

Much help appreciated. 

[amitchandak · Accepted solution]

@Anonymous ,

Countx(filter(Addcolumns(Summarize(Fact, Fact[Project ID],Fact[Name], Date[Month Year]), "_1", [Measure]) , [_1] =1) , [Project Id])