Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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.
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.
Thank you- this has worked well!
Count123 = COUNTROWS(FILTER(YourTable, YourTable[YourColumn] IN {1, 2, 3}))
Did I answer your question? If so, please mark my post as a solution!
Proud to be a Super User!
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?