How to do a COUNTIF across rows

[Anonymous]

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

[amitchandak · Accepted solution]

@Anonymous 

Better you unpivot and create a measure and pivot it in Matrix Visual

https://radacad.com/pivot-and-unpivot-with-power-bi

[Anonymous]

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.