How to Count number of rows in every columns and store it in a new column

[Anonymous]

Hi,
I am just practicing some formulas on Power BI. I have one simple excel file which have some name(Player) columns with their scores.
Now i want to add one new column in a table which will count the number of zeros get for each player.

Please help me with this. Sharing the table screenshot 

[Anonymous]

Hi , @Anonymous 

Based on your description, I'm wondering if the value 0 in your table needs to be counted.

I created the same sample as you and unpivot columns like this:

You can refer to the documentation for details:Unpivot columns - Power Query | Microsoft Learn

Result is as follows :

Please feel free to correct me and provide more information if I have misunderstood you!

An attachment for your reference. Hope it helps!

Best regards,
Community Support Team_ Scott Chang

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi @Anonymous 

I understood the given solution but i want to count number of zeros for every person seperately and show it on other table like example sumit got 2 zeros and deepak got 5 zeros. This result i want to execute. sharing the sample table from which you can understand the requirement.

 Thanks!!