Custom Column to count non-blank cells across columns

[YcnanPowerBI]

Hello

I am trying to count non blank fields across a row that are not in order.  As an example, I only want it to look at columns B,C,& E to provide that count.  How am I able to achieve this?

A	B	C	D	E	F	Count
20	4		5		4	1

Any help GREATLY appreciated.

[YcnanPowerBI]

Thank you! It worked!

[Anonymous]

Hi @YcnanPowerBI ,

If I understand correctly, the issue is that you want to count non-blank fields across a row. Please try the following methods and check if they can solve your problem:

1.Create the simple Table.

2.Select the table and click on New column to create a custom column.

3.Enter the following DAX formula for the new column.

Column = 
VAR CountB = IF(NOT(ISBLANK('Table'[B])), 1, 0)
VAR CountC = IF(NOT(ISBLANK('Table'[C])), 1, 0)
VAR CountE = IF(NOT(ISBLANK('Table'[E])), 1, 0)
RETURN CountB + CountC + CountE

4.Drag the new column into the table visual.

5.The result is shown below.

Looking forward to your reply.

Best Regards,

Wisdom Wu

[Ahmedx · Accepted solution]

pls try this