CODEWITHSUNDEEP
powerbidax
duman kurenbaev
duman kurenbaev

Reputation: 19

The COUNT function only accepts a column reference as an argument

I created formula

RRC SR < 98% = CALCULATE(COUNT(x_TOPN_new_daily[RRC Setup Success Rate] <98))

to measure value less than 98 on column RRC Setup Success Rate but it gives error "The COUNT function only accepts a column reference as an argument.", Do u have any idea?

City RRC Setup Success Rate
B 100​
A 96​
C 94​
F 95​
R 99​
C 97​

I want to get count result where less than 98

Upvotes: 1

Views: 2745

Answers (2)

EbruB.
EbruB.

Reputation: 116

RRC SR < 98% = 
CALCULATE(
      COUNT(x_TOPN_new_daily[RRC Setup Success Rate])
     ,FILTER(x_TOPN_new_daily, x_TOPN_new_daily[RRC Setup Success Rate]<98)
)

An alternative solution.

Upvotes: 0

Peter
Peter

Reputation: 12375

Use this measure

RRC SR < 98% =
CALCULATE (
    COUNT ( x_TOPN_new_daily[RRC Setup Success Rate] ),
    x_TOPN_new_daily[RRC Setup Success Rate] < 98
)

Upvotes: 1

Related Questions