Forum Discussion
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 use for the Total ID column? Thanks in advance.
| ID1 | ID2 | ID3 | Total ID |
| 1aa | 1bb | 1cc | 3 |
| 2bb | 2cc | 2 | |
| 1ss | 1 |
Hi,
Please check the below picture and the attached pbix file.
Total ID count CC = ( 'Table'[ID1] <> BLANK () ) + ( 'Table'[ID2] <> BLANK () ) + ( 'Table'[ID3] <> BLANK () )Great. Thanks a lot 🙂
2 Replies
Hi,
Please check the below picture and the attached pbix file.
Total ID count CC = ( 'Table'[ID1] <> BLANK () ) + ( 'Table'[ID2] <> BLANK () ) + ( 'Table'[ID3] <> BLANK () )Great. Thanks a lot 🙂