Sumif function in Power BI

[Anonymous]

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?

[dax]

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.

[Asac_14]

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:)

[Anonymous]

Doesnt work actually

[Asac_14]

What error you are getting ? @Anonymous 

---

@Anonymous wrote:

Doesnt work actually

---