Using AND expression in DISTINCT COUNT

[Anonymous]

Hello, 

I'm trying to get a new measure to work, basically I want it to find the percentage of rows that meet two conditions. It says it can't have data from 2 columns. Is there something similar to the measure below that will give me what I need?

% C6 NEEDS Deal = CALCULATE(DISTINCTCOUNT('C6 needs TUNED IN'[uuid: Respondent identifier]), 'C6 needs TUNED IN'[C6 NEEDS Tuned in]= "Deal" && 'C6 needs TUNED IN'[C6 Needs tuned in response] = "Selected") / DISTINCTCOUNT('C6 needs TUNED IN'[uuid: Respondent identifier])

Thanks in advance!

[Thejeswar]

Hi @Anonymous ,

Can you share some sample data ?

That would make it easier for us to help..

[Anonymous]

Hi @Thejeswar , 

Unfortunately its client data so im unable to share it. Basically the measure should count the number of rows which meet the conditions in each of those columns (e.g. say 'Deal' and 'Selected'), then divide by the unique number of IDs in the table to get the percentage.

Thanks for your help!

[evandrocunico · Accepted solution]

Hi @Anonymous 

try change && by comma... e use DIVIDE... show blank(), when DISTINCTCOUNT('C6 needs TUNED IN'[uuid: Respondent identifier]) is zero.

% C6 NEEDS Deal = divide(CALCULATE(DISTINCTCOUNT('C6 needs TUNED IN'[uuid: Respondent identifier]), 'C6 needs TUNED IN'[C6 NEEDS Tuned in]= "Deal" , 'C6 needs TUNED IN'[C6 Needs tuned in response] = "Selected") , DISTINCTCOUNT('C6 needs TUNED IN'[uuid: Respondent identifier]))

Regards.

[Anonymous]

Hi @evandrocunico ,

I think that works, thanks for the suggestion!