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 c...
Need Help
Show and Tell
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