Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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?
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
86 | |
84 | |
66 | |
62 | |
61 |
User | Count |
---|---|
199 | |
120 | |
110 | |
79 | |
69 |