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
    
# CodeColumn 1column 2Total Count
1111FS1
2222FS1
3333F 1
4444FS1
5555V  
6666F 1
  S1
    
Total Count   6

 

Thanks

Need Help

6 Replies

  • Anand24's avatar
    Anand24
    Icon for Super User rankSuper User
    2 years ago

    Hi CJ_96601 ,
    Create a new calculated column with below DAX:

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

     

    Here's the result:


     

    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

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi CJ_96601 ,

     

    According to your statement, I suggest you to try code as below to create the measure.

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

    Result is as below.

     

    Best Regards,
    Rico Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

    • Anand24's avatar
      Anand24
      Icon for Super User rankSuper 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