topic Re: Changing the reference data in a table with a slicer in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Changing-the-reference-data-in-a-table-with-a-slicer/m-p/3860420#M150801 <P>Wowowo, easy on the sample data!&nbsp; I have adjusted it to something more realistic.</P> <P>&nbsp;</P> <P><img /></P> <P>&nbsp;</P> <P>Here's one possible implementation.</P> <P>&nbsp;</P> <P><img /></P> <P>&nbsp;</P> <P>&nbsp;</P> Mon, 22 Apr 2024 21:32:10 GMT lbendlin 2024-04-22T21:32:10Z Changing the reference data in a table with a slicer https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Changing-the-reference-data-in-a-table-with-a-slicer/m-p/3859274#M150737 <TABLE border="1"><TBODY><TR><TD><FONT color="#0000FF"><STRONG>Car</STRONG></FONT></TD><TD><FONT color="#0000FF"><STRONG>Mass</STRONG></FONT></TD><TD><FONT color="#0000FF"><STRONG>Delta Mass</STRONG></FONT></TD></TR><TR><TD><FONT color="#FF0000">VW Beetle</FONT></TD><TD>2000kg</TD><TD>0</TD></TR><TR><TD>Q7</TD><TD>2500kg</TD><TD>+500kg</TD></TR><TR><TD>BMW 3 series</TD><TD>2200kg</TD><TD>+200kg</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Hello all,</P><P>&nbsp;</P><P>I have a table like the one above. The delta Mass is now calculated using the VW Beetle as a reference.</P><P>&nbsp;</P><P>Now I want to select the reference Car by picking it from a list (e.g. from a slicer).&nbsp;</P><P>&nbsp;</P><P>So if I pick the Q7 for example it should look like this:</P><P>&nbsp;</P><TABLE border="1"><TBODY><TR><TD><FONT color="#0000FF"><STRONG>Car</STRONG></FONT></TD><TD><FONT color="#0000FF"><STRONG>Mass</STRONG></FONT></TD><TD><FONT color="#0000FF"><STRONG>Delta Mass</STRONG></FONT></TD></TR><TR><TD>VW Beetle</TD><TD>2000kg</TD><TD>-500kg</TD></TR><TR><TD><FONT color="#FF0000">Q7</FONT></TD><TD>2500kg</TD><TD>0</TD></TR><TR><TD>BMW 3 series</TD><TD>2200kg</TD><TD><P>-300kg</P></TD></TR></TBODY></TABLE><P>&nbsp;</P><P>How is that done in Power BI?</P><P>Thanks for helping.</P><P>Alex</P> Mon, 22 Apr 2024 12:31:08 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Changing-the-reference-data-in-a-table-with-a-slicer/m-p/3859274#M150737 Alexxx 2024-04-22T12:31:08Z Re: Changing the reference data in a table with a slicer https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Changing-the-reference-data-in-a-table-with-a-slicer/m-p/3860420#M150801 <P>Wowowo, easy on the sample data!&nbsp; I have adjusted it to something more realistic.</P> <P>&nbsp;</P> <P><img /></P> <P>&nbsp;</P> <P>Here's one possible implementation.</P> <P>&nbsp;</P> <P><img /></P> <P>&nbsp;</P> <P>&nbsp;</P> Mon, 22 Apr 2024 21:32:10 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Changing-the-reference-data-in-a-table-with-a-slicer/m-p/3860420#M150801 lbendlin 2024-04-22T21:32:10Z Re: Changing the reference data in a table with a slicer https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Changing-the-reference-data-in-a-table-with-a-slicer/m-p/3861589#M150854 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="100342" data-lia-user-login="lbendlin" class="lia-mention lia-mention-user">lbendlin</a>&nbsp;Thank you very much!!! Works like a charm.</P> Tue, 23 Apr 2024 08:36:00 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Changing-the-reference-data-in-a-table-with-a-slicer/m-p/3861589#M150854 Alexxx 2024-04-23T08:36:00Z