Calculating a COUNT of a measure

[Joak]

Hello, 

I have to count a calculated measure which is based on this formula :

AVERAGEX(
	KEEPFILTERS(VALUES('Data'[MatchingKey]));
	CALCULATE(SUM('Data'[LondonOccupencyRate])
))

I aim to count how many of those measures are above 1. 

I tried to just add the formula "COUNT()" before this one, but it doesn't work. 

Also, I'd like to know wether it was possible or not to automaticcaly build a new table with lines that doesn't contains null or zero. 

If anybody has already been faced with this kind of issue, don't hesitate 🙂 

Thanks

[Joak]

In fact I realize the problem might be more complicated than what I described. 

What I want to do is to sum lines that have the same matching key, and then compare it. 

The table look like that : 

MatchingKey          %a          %b          %total

ABC123                   20%

ABC123                                 23%            43%

ABC456                   15%    

ABC456                                 18%            33%

ABC789                   32%           

ABC789                                  12%            44%

And then be able to build a last column with "TRUE"

if   %total< x%

BUT %a > y%

[v-chuncz-msft · Accepted solution]

@Joak,

With table and matrix visual, you just need to add a measure.

Measure =
IF ( SUM ( Table1[%total] ) < 0.8 && SUM ( Table1[%a] ) > 0.3, TRUE () )