Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Sumif function in Power BI

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?

Need Help
Show and Tell

4 Replies

  • Asac_14's avatar
    Asac_14
    Resolver I
    6 years ago

    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's avatar
      Anonymous
      Not applicable
      6 years ago

      Doesnt work actually

      • Asac_14's avatar
        Asac_14
        Resolver I
        6 years ago

        What error you are getting ? Anonymous 

        Anonymous wrote:

        Doesnt work actually

         

  • dax's avatar
    dax
    Community Support
    6 years ago

    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.