Measure that can count several numeric answers in column

[EIJ]

Hi there, 

I have a column in a table in which people can answer 1-10 on a scale. 

I am trying to do a count of all the answers containing 1,2 &3 within that column. 

does anyone know how to do this? I know how to count words and also 0 but not multiple numbers 😞 

thank you in advance 

[v-weiyan1-msft · Accepted solution]

Hi @EIJ ,

@mh2587 nice method! Thank you, for your quick response and the solution provided.
And you can also try code as below to create measure.

My Sample:

Count123 = 
SUMX ( 'Table', IF ( 'Table'[Answer] IN { 1, 2, 3 }, 1, 0 ) )

In the Visualizations pane, select the Card icon and put the measure in the card visualization.
Result is as below.

Is this the result you expect?

Best Regards,
Yulia Yan

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[EIJ]

Thank you- this has worked well!

[mh2587]

Count123 = COUNTROWS(FILTER(YourTable, YourTable[YourColumn] IN {1, 2, 3}))

[EIJ]

Thank you. I've tried to use it but how does it show me the total figure? Does it need extra formula to do that?