Forum Discussion

uc's avatar
uc
Helper II
3 years ago
Solved

Dax statement help

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 ...
Need Help
  • Jihwan_Kim's avatar
    Jihwan_Kim
    3 years ago

    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's avatar
    uc
    3 years ago

    Great. Thanks a lot 🙂

Jihwan_Kim's avatar
Jihwan_Kim
Super User
3 years ago

Hi,

Please check the below picture and the attached pbix file.

 

 

 

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