Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Using AND expression in DISTINCT COUNT

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 simila...
Need Help
  • evandrocunico's avatar
    evandrocunico
    7 years ago

    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.

evandrocunico's avatar
evandrocunico
Resolver III
7 years ago

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's avatar
Anonymous
Not applicable
7 years ago

Hi evandrocunico ,

 

I think that works, thanks for the suggestion!