Count of average score between 1 and 2

[Anonymous]

Hello,

Thanks to @amitchandak  I have a measure that shows the number of average scores equal to 1, however when I try to change it to between 1 and 2, I'm receiving an error message. My current measure is below, I'm trying to change it to 1 < [average_] < 2. 

Any Ideas?

Count of urgent = 
CALCULATE (
DISTINCTCOUNT ('Table'[Section] ),
FILTER (
SUMMARIZE (
'Table',
'Table'[Country],
'Table'[Section],
"average_", AVERAGE ( 'Table'[Score] )
),
[average_] = 1
)
)

[Syndicate_Admin · Accepted solution]

[average_] >= 1 && [average_] <= 2

[Anonymous]

That's annoyingly simple! 🙂 Thanks @Syndicate_Admin