Forum Discussion
Using AND expression in DISTINCT COUNT
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.
Hi Anonymous ,
Can you share some sample data ?
That would make it easier for us to help..
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!
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.