Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Solved! Go to 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.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
85 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
100 | |
87 | |
68 |