Distinct count from two column if either statement is true

[CJ_96601]

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
# Code	Column 1	column 2	Total Count
1111	F	S	1
2222	F	S	1
3333	F		1
4444	F	S	1
5555	V
6666	F		1
		S	1
Total Count			6

Thanks

[CJ_96601]

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

[Anand24]

@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

[v-rzhou-msft]

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.

[CJ_96601]

It gives an error...

Issue not solve

[Anand24]

@CJ_96601 ,
What error do you receive?

[Anand24]

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