Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

How to do a COUNTIF across rows

Hi All,

 

I'm trying to work out how to do a countif across a single row of data.  

 

Example of my work is 

 

 

 

 

 

Where:

1 = Not Required

2 = Required

3 = Sent

4 = Retry

 

The standard formula I know I can use in excel is =COUNTIF(A3:H3,1) and it will return 2 in J3 and with minor variances, it will return 6 in K3 and so on. I also know in the COUNTIF function I can utilise the word "Not Required" if the data wasn't converted to a numeric value and it will still return the same results

 

 

How do you do this in a PowerBi desktop? 

 

Cheers,

 

Sandii

 

Need Help

2 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi Amitchandak! amitchandak   

       

      Thanks for that, I didn't think to pivot would work but that has fixed my issue and haven't bothered to unpivot the data as it can stay that one for that one table. 

       

      Can do the same for similar data within the same dataset.