Count percentage greater than 100

[Anonymous]

Good morning,

I need some assistance, please.

I would like to count the occurrence of how many times a percentage value is greater than 100

Please see below for my current formula and result.

it is only counting some of the values, not all

Formula: 

GSM>100 = COUNTAX(FILTER('Market Revenue Forecast','Market Revenue Forecast'[MRR GSM Percentage Achieved]>1 ),'Market Revenue Forecast'[MRR GSM Percentage Achieved])

LInk : <https://snipboard.io/xZpa3V.jpg>

@amitchandak   @parry2k   @PhilipTreacy 

[Anonymous · Accepted solution]

Issue resolved: I was filtering by the wrong table instead od Market revenue forecast it should be the User table

Correct measure : GSM>100 = COUNTAX(FILTER('User','Market Revenue Forecast'[MRR GSM Percentage Achieved]>1 ),'Market Revenue Forecast'[MRR GSM Percentage Achieved])