Forum Discussion

CJ_96601's avatar
CJ_96601
Helper V
2 years ago

Distinct count from two column if either statement is true

Distinct count from two column if either statement is true.     you may refer to below table - result is in the last column.   distinct Count column 1 and column 2          Result    ...
Need Help
CJ_96601's avatar
CJ_96601
Helper V
2 years ago

|| 'Table'[column 2]   - it says token "," expected  

  • Anand24's avatar
    Anand24
    Super User
    2 years ago

    CJ_96601 ,
    Create a calculated column with below DAX:

    Total Count =
    IF(
        'Table'[Column 1] = "F" || 'Table'[column 2] <> BLANK(),
        1,
        BLANK()
    )

     

    Here's the result:

    In case this doesn't work, please share a screenshot of error.

     

    Give a Thumbs Up if this post helped you in any way and Mark This Post as Solution if it solved your query !!!

    Proud To Be a Super User !!!
    LinkedIn