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 Folks,
I have a table where I want to count number of specific text in a column. How can I do that?
My coloumn name is Observation
Values there are "SU", "SW", SO.
So how can I apply count if?
Hi bhuvanasundar,
I can't reproduce your problem based on your desription, so if possible, could you please inform me in details(such as your sample data, your expected output or the error you get currently)? Then I will help you more correctly.
Please do mask sensitive data before uploading.
Thanks for your understanding and support.
Best Regards,
Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Create a Calculated column as Count=1
Create a measure for each of the group like:
Count of SU = calculate(sum(Count),Observation="SU")
Count of SW = calculate(sum(Count),Observation="SW")
Count of SO = calculate(sum(Count),Observation="SO")
@Anonymous if it helps please give a Kudos:)
Doesnt work actually
What error you are getting ? @Anonymous
@Anonymous wrote:Doesnt work actually
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 |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |