topic Re: Handling Multiple Selection Values in Power BI DAX in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Handling-Multiple-Selection-Values-in-Power-BI-DAX/m-p/3328631#M124673 <P>Thank you so much! This worked like a charm&nbsp;<span class="lia-unicode-emoji" title=":smiling_face_with_smiling_eyes:">😊</span></P> Thu, 13 Jul 2023 06:04:28 GMT agcruz 2023-07-13T06:04:28Z Handling Multiple Selection Values in Power BI DAX https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Handling-Multiple-Selection-Values-in-Power-BI-DAX/m-p/3328369#M124659 <P><SPAN>I have a survey with 3 questions. 2 of which are "Yes" and "No" questions, while one is a multiple choice (can have more than one selection) question where the answer only counts as "Yes" if all four choices are selected. Create Power BI DAX formulas on how to calculate the % of "Yes" answers per question out of all distinct users.</SPAN></P><P>&nbsp;</P><P><SPAN>Dividing by distinct users will not work as this survey is 1 out of 3 surveys in my table and each survey will have different users who answered them.</SPAN></P><P>&nbsp;</P><P><SPAN>Sample Table:<BR /></SPAN></P><TABLE border="1"><TBODY><TR><TD>User</TD><TD>Survey No.</TD><TD>Question No.</TD><TD>Answer</TD></TR><TR><TD>1</TD><TD>1</TD><TD>1</TD><TD>Yes</TD></TR><TR><TD>1</TD><TD>1</TD><TD>2</TD><TD>Yes</TD></TR><TR><TD>1</TD><TD>1</TD><TD>3</TD><TD>Option 1</TD></TR><TR><TD>1</TD><TD>1</TD><TD>3</TD><TD>Option 2</TD></TR><TR><TD>1</TD><TD>1</TD><TD>3</TD><TD>Option 3</TD></TR><TR><TD>1</TD><TD>1</TD><TD>3</TD><TD>Option 4</TD></TR><TR><TD>2</TD><TD>1</TD><TD>1</TD><TD>Yes</TD></TR><TR><TD>2</TD><TD>1</TD><TD>2</TD><TD>No</TD></TR><TR><TD>2</TD><TD>1</TD><TD>3</TD><TD>Option 1</TD></TR><TR><TD>3</TD><TD>2</TD><TD>1</TD><TD>Yes</TD></TR><TR><TD>3</TD><TD>2</TD><TD>2</TD><TD>No</TD></TR></TBODY></TABLE><P><SPAN>&nbsp;</SPAN></P><P><SPAN>Expected % Yes:<BR />Survey 1, Question 1: 100%<BR />Survey 1, Question 2: 50%<BR />Survey 1, Question 3: 50%<BR />Survey 2, Question 1: 100%<BR />Survey 2, Question 2: 0%</SPAN></P> Thu, 13 Jul 2023 02:10:42 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Handling-Multiple-Selection-Values-in-Power-BI-DAX/m-p/3328369#M124659 agcruz 2023-07-13T02:10:42Z Re: Handling Multiple Selection Values in Power BI DAX https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Handling-Multiple-Selection-Values-in-Power-BI-DAX/m-p/3328488#M124668 <P><EM><STRONG><A href="https://1drv.ms/u/s!AsDP3LYI8umspTr-OsH_RtC42OzA?e=KycUcw" target="_blank" rel="noopener">Survey.pbix</A></STRONG></EM></P><P>&nbsp;</P><P><img /></P> Thu, 13 Jul 2023 03:28:12 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Handling-Multiple-Selection-Values-in-Power-BI-DAX/m-p/3328488#M124668 ThxAlot 2023-07-13T03:28:12Z Re: Handling Multiple Selection Values in Power BI DAX https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Handling-Multiple-Selection-Values-in-Power-BI-DAX/m-p/3328631#M124673 <P>Thank you so much! This worked like a charm&nbsp;<span class="lia-unicode-emoji" title=":smiling_face_with_smiling_eyes:">😊</span></P> Thu, 13 Jul 2023 06:04:28 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Handling-Multiple-Selection-Values-in-Power-BI-DAX/m-p/3328631#M124673 agcruz 2023-07-13T06:04:28Z