Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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! | |
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
104 | |
101 | |
79 | |
72 | |
64 |
User | Count |
---|---|
143 | |
109 | |
103 | |
82 | |
74 |