DAX: Count the number of items based on one condition

[LABrowne]

Hi there,

I am trying to create a formula that counts the number orders based on a condition (order sat) with a value greater than 100% and it is returning blanks please see what I have below:

Order Count (OrderSat > 100%) = COUNTX(VALUES(Order[OrderNumber]),IF([OrderSat (%)] > 100,1))

Any help would be greatly appreciated.

[LABrowne]

Yes I figured out it had to be 1 and not 100! Thanks.

[FreemanZ]

is [OrderSat (%)] a measure or column?

[LABrowne]

Hi it is a measure.

[FreemanZ · Accepted solution]

is 100 actually 100%?