Count columns if they fit with any condition ( countif )

[CarlosGonzalezC]

Hi dear Community,

In Power BI (Desktop)

I have 20 columns with numbers and and I need to count them if they match with a value (i.e. count if the column's value = 0) 

 I need to create a new column with this count

Any advice how I can calculate it, since the countif function (for columns) does not exist in Power Bi

I appreciate your help

Carlos G.

[Zubair_Muhammad]

@CarlosGonzalezC 

With Query Editor, We can add a custom Column like

List.Count(List.Select(Record.ToList(_),each _ =0))

[CarlosGonzalezC]

Thanks a lot for your help..

It worked, but I would like to understand it better.

Could you try to explain it in a few words?...pleaseee... I appreciate it

Thanks a lot

Carlos G.

[CarlosGonzalezC]

Hi Zubair, 

Actually, I would like to know how I can specify a contigous range of columns in order to apply this "count if"...

How I can do it?

Below the 3 columns that I need to apply this "Count If"

[v-lili6-msft]

HI @CarlosGonzalezC 

You could use IF Functions in Power Query Including Nested IF for these three columns

https://www.computergaga.com/blog/if-functions-in-power-query-including-nested-ifs/

For example:

if [Column1]" and [Column2] and [Column3] then <Your expected outrput> else <Your other output>

Regards,

Lin