topic Trying to populate a slicer with Measures in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Trying-to-populate-a-slicer-with-Measures/m-p/1624341#M32817 <P>I have the following table with COURSE FAILURES.</P><P>I have two measures that pull from below table:</P><DIV><DIV class="lia-indent-padding-left-30px"><SPAN><STRONG>Course Failures- Sem 1</STRONG> = </SPAN></DIV><DIV class="lia-indent-padding-left-30px"><SPAN>COUNTX(</SPAN></DIV><DIV class="lia-indent-padding-left-30px"><SPAN>FILTER(</SPAN></DIV><DIV class="lia-indent-padding-left-30px"><SPAN>Append1,</SPAN></DIV><DIV class="lia-indent-padding-left-30px"><SPAN>Append1[SEMESTER GRADE] = "F"</SPAN></DIV><DIV class="lia-indent-padding-left-30px"><SPAN>&amp;&amp; Append1[SEMESTER] = "SEM 1"</SPAN></DIV><DIV class="lia-indent-padding-left-30px"><SPAN>),</SPAN></DIV><DIV class="lia-indent-padding-left-30px"><SPAN>Append1[SEMESTER GRADE]</SPAN></DIV><DIV class="lia-indent-padding-left-30px"><SPAN>)</SPAN></DIV><DIV class="lia-indent-padding-left-30px">&nbsp;</DIV><DIV class="lia-indent-padding-left-30px"><DIV><DIV><SPAN><STRONG>Course Failures- Sem 2</STRONG> = </SPAN></DIV><DIV><SPAN>COUNTX(</SPAN></DIV><DIV><SPAN>FILTER(</SPAN></DIV><DIV><SPAN>Append1,</SPAN></DIV><DIV><SPAN>Append1[SEMESTER GRADE] = "F"</SPAN></DIV><DIV><SPAN>&amp;&amp; Append1[SEMESTER] = "SEM 2"</SPAN></DIV><DIV><SPAN>),</SPAN></DIV><DIV><SPAN>Append1[SEMESTER GRADE]</SPAN></DIV><DIV><SPAN>)</SPAN></DIV></DIV></DIV></DIV><P>&nbsp;</P><P>I need to create 2 slicers based upon these measures and have no idea how to do this. Any help would be deeply appreciated. Do I need to create a table that summarizes these measures? Stuck:(</P><P>&nbsp;</P><P>Table below:</P><TABLE><TBODY><TR><TD>Title</TD><TD>Student</TD><TD>SEMESTER GRADE</TD><TD>COURSE FAILURES</TD><TD>SEMESTER</TD></TR><TR><TD>123456</TD><TD>BROWN, CHARLIE</TD><TD>F</TD><TD>2</TD><TD>SEM 2</TD></TR><TR><TD>236548</TD><TD>BROWN, LUCY</TD><TD>F</TD><TD>6</TD><TD>SEM 2</TD></TR><TR><TD>365489</TD><TD>BROWN, SNOOPY</TD><TD>F</TD><TD>2</TD><TD>SEM 2</TD></TR><TR><TD>365489</TD><TD>BROWN, SNOOPY</TD><TD>F</TD><TD>1</TD><TD>SEM 1</TD></TR><TR><TD>169872</TD><TD>CUNNINHAM, RICHIE</TD><TD>F</TD><TD>3</TD><TD>SEM 2</TD></TR><TR><TD>169872</TD><TD>CUNNINHAM, RICHIE</TD><TD>F</TD><TD>1</TD><TD>SEM 1</TD></TR></TBODY></TABLE> Tue, 26 Jan 2021 17:26:37 GMT slhangen 2021-01-26T17:26:37Z Trying to populate a slicer with Measures https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Trying-to-populate-a-slicer-with-Measures/m-p/1624341#M32817 <P>I have the following table with COURSE FAILURES.</P><P>I have two measures that pull from below table:</P><DIV><DIV class="lia-indent-padding-left-30px"><SPAN><STRONG>Course Failures- Sem 1</STRONG> = </SPAN></DIV><DIV class="lia-indent-padding-left-30px"><SPAN>COUNTX(</SPAN></DIV><DIV class="lia-indent-padding-left-30px"><SPAN>FILTER(</SPAN></DIV><DIV class="lia-indent-padding-left-30px"><SPAN>Append1,</SPAN></DIV><DIV class="lia-indent-padding-left-30px"><SPAN>Append1[SEMESTER GRADE] = "F"</SPAN></DIV><DIV class="lia-indent-padding-left-30px"><SPAN>&amp;&amp; Append1[SEMESTER] = "SEM 1"</SPAN></DIV><DIV class="lia-indent-padding-left-30px"><SPAN>),</SPAN></DIV><DIV class="lia-indent-padding-left-30px"><SPAN>Append1[SEMESTER GRADE]</SPAN></DIV><DIV class="lia-indent-padding-left-30px"><SPAN>)</SPAN></DIV><DIV class="lia-indent-padding-left-30px">&nbsp;</DIV><DIV class="lia-indent-padding-left-30px"><DIV><DIV><SPAN><STRONG>Course Failures- Sem 2</STRONG> = </SPAN></DIV><DIV><SPAN>COUNTX(</SPAN></DIV><DIV><SPAN>FILTER(</SPAN></DIV><DIV><SPAN>Append1,</SPAN></DIV><DIV><SPAN>Append1[SEMESTER GRADE] = "F"</SPAN></DIV><DIV><SPAN>&amp;&amp; Append1[SEMESTER] = "SEM 2"</SPAN></DIV><DIV><SPAN>),</SPAN></DIV><DIV><SPAN>Append1[SEMESTER GRADE]</SPAN></DIV><DIV><SPAN>)</SPAN></DIV></DIV></DIV></DIV><P>&nbsp;</P><P>I need to create 2 slicers based upon these measures and have no idea how to do this. Any help would be deeply appreciated. Do I need to create a table that summarizes these measures? Stuck:(</P><P>&nbsp;</P><P>Table below:</P><TABLE><TBODY><TR><TD>Title</TD><TD>Student</TD><TD>SEMESTER GRADE</TD><TD>COURSE FAILURES</TD><TD>SEMESTER</TD></TR><TR><TD>123456</TD><TD>BROWN, CHARLIE</TD><TD>F</TD><TD>2</TD><TD>SEM 2</TD></TR><TR><TD>236548</TD><TD>BROWN, LUCY</TD><TD>F</TD><TD>6</TD><TD>SEM 2</TD></TR><TR><TD>365489</TD><TD>BROWN, SNOOPY</TD><TD>F</TD><TD>2</TD><TD>SEM 2</TD></TR><TR><TD>365489</TD><TD>BROWN, SNOOPY</TD><TD>F</TD><TD>1</TD><TD>SEM 1</TD></TR><TR><TD>169872</TD><TD>CUNNINHAM, RICHIE</TD><TD>F</TD><TD>3</TD><TD>SEM 2</TD></TR><TR><TD>169872</TD><TD>CUNNINHAM, RICHIE</TD><TD>F</TD><TD>1</TD><TD>SEM 1</TD></TR></TBODY></TABLE> Tue, 26 Jan 2021 17:26:37 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Trying-to-populate-a-slicer-with-Measures/m-p/1624341#M32817 slhangen 2021-01-26T17:26:37Z Re: Trying to populate a slicer with Measures https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Trying-to-populate-a-slicer-with-Measures/m-p/1624379#M32819 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="101476" data-lia-user-login="slhangen" class="lia-mention lia-mention-user">slhangen</a>&nbsp;</P> <P>&nbsp;</P> <P>Actually not clear, please share the dummy pbix if possible.</P> Tue, 26 Jan 2021 17:50:37 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Trying-to-populate-a-slicer-with-Measures/m-p/1624379#M32819 mhossain 2021-01-26T17:50:37Z Re: Trying to populate a slicer with Measures https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Trying-to-populate-a-slicer-with-Measures/m-p/1624561#M32823 <P>Not sure how to do that, my apologies.</P> Tue, 26 Jan 2021 20:11:40 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Trying-to-populate-a-slicer-with-Measures/m-p/1624561#M32823 slhangen 2021-01-26T20:11:40Z Re: Trying to populate a slicer with Measures https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Trying-to-populate-a-slicer-with-Measures/m-p/1624583#M32826 <P>Ok, I think I replicated here:</P><P><A href="https://www.dropbox.com/s/8okz5w4asjeslgl/TableFromMeasureSample.pbix?dl=0" target="_blank">https://www.dropbox.com/s/8okz5w4asjeslgl/TableFromMeasureSample.pbix?dl=0</A></P> Tue, 26 Jan 2021 20:45:53 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Trying-to-populate-a-slicer-with-Measures/m-p/1624583#M32826 slhangen 2021-01-26T20:45:53Z Re: Trying to populate a slicer with Measures https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Trying-to-populate-a-slicer-with-Measures/m-p/1624805#M32834 <P><img /></P> <P>&nbsp;</P> Wed, 27 Jan 2021 01:23:29 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Trying-to-populate-a-slicer-with-Measures/m-p/1624805#M32834 wdx223_Daniel 2021-01-27T01:23:29Z