Dax statement help

[uc]

Hello 

Need help with dax. I have a table below with 4 columns and the last column is the count of first 3 columns, provided they have data in it. Can you please advise what dax statement I need to use for the Total ID column? Thanks in advance.

ID1	ID2	ID3	Total ID
1aa	1bb	1cc	3
	2bb	2cc	2
1ss			1

[Jihwan_Kim · Accepted solution]

Hi,

Please check the below picture and the attached pbix file.

Total ID count CC =
( 'Table'[ID1] <> BLANK () )
    + ( 'Table'[ID2] <> BLANK () )
    + ( 'Table'[ID3] <> BLANK () )

[uc · Accepted solution]

Great. Thanks a lot 🙂

[Jihwan_Kim · Accepted solution]

Hi,

Please check the below picture and the attached pbix file.

Total ID count CC =
( 'Table'[ID1] <> BLANK () )
    + ( 'Table'[ID2] <> BLANK () )
    + ( 'Table'[ID3] <> BLANK () )