Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi All,
Looking for an answer if it is possible to count the amount of times a word is mentioned within a column. For example we have a column with different selections such as Closed, Expired, Open, Started, Hold and In-Contract. Is it possible to count the amount of times Closed is in the column?
Also can I do the same for a RAG status looking to count the amount of Red's, Amber's and Green's?
Thanks in Advance
Solved! Go to Solution.
Hello @GH21 ,
Please remove the Bracket ( before the calculate
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Proud to be a Super User! | |
Hello @GH21 ,
try this
Count of Expired= calculate(countrows(tableName), column = "Expired")
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Proud to be a Super User! | |
Hello @GH21 ,
Please remove the Bracket ( before the calculate
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Proud to be a Super User! | |
User | Count |
---|---|
92 | |
85 | |
77 | |
66 | |
62 |
User | Count |
---|---|
110 | |
95 | |
95 | |
64 | |
59 |