Using a "New Column" to Count values in 4 other columns

[jrous]

Hi - I am brand new to Power BI - so my thanks in advance for your help to what I hope is a simple solution that I just haven't been able to find yet.

I have data that looks something like the following:

I want to be able to add a calculated column to the table in Power BI that shows "Number of Modules Completed", like this:

Because ultimately what I would like to do is show a visualisation that shows the number of people that have completed 1, 2, 3, or 4 modules of the training:

I thought perhaps I could do this by adding a "New Column" to the table in power bi, but using "COUNT" in the formula, counts up all the modules in the entire column - not on a per-row basis.  I essentially need the calculated column to count modules completed on a per-row basis.

Thanks for your advice!

[Zubair_Muhammad · Accepted solution]

Hi @jrous 

Try following

Column =
COUNTROWS ( FILTER ( { [Mod1], [Mod2], [Mod3], [Mod4] }, [Value] <> BLANK () ) )