Count columns with a value greater than 0

[Liam01]

Hi,

I've searched everywhere for this and seem unable to find an answer!

I'm wanting a measure to count the columns, in a specified range of columns, whereby the value is greater than 0. I've included an example of how this would look - The Count column is the result of the measure and, for example, column A isn't being counted as it's not relevant.

Any help would be much appreciated.

Thanks 

[davehus · Accepted solution]

Hi @Liam01 ,

Try something like this. 

Columns Populated = VAR B_C = IF(SUM(Test[B])>=1,1,0)
VAR C_C = IF(SUM(Test[C])>=1,1,0)
VAR D_C = IF(SUM(Test[D])>=1,1,0)
VAR E_C = IF(SUM(Test[E])>=1,1,0)
RETURN B_C+C_C+D_C+E_C

[Liam01]

Hi,

I'm returning to this as I need this to do something slightly different and hopefully you may be able to help.

As it works at the minute, it counts the items but if a job appears twice with a B in each occurrence, it will still only return 1. 

I guess i'm wanting this measure to do a count rather than a distinct count, as in the photo below - Top table shows data, bottom shows when it's combined by job number.

So if a job appears twice and each occurrence has an A, the bottom table would show 2. Hopefully that makes sense.

Thanks

[Liam01]

Hi @davehus,

That's great, thanks for that - seems to be just what I was after.

Cheers