https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Change-the-Column-or-Measure-Value-in-a-Power-BI-Visual-by/m-p/1249896#M20566 <P>Hello everyone!</P><P>I have seen the fantastic video of RADACAD of how to use a parameter table to filter between some measures.</P><P><A href="https://www.youtube.com/watch?v=_sxLEGRCo28" target="_blank">https://www.youtube.com/watch?v=_sxLEGRCo28</A></P><P>&nbsp;</P><P>This approach is really awesome!</P><P>I need to extend this approach to filter between the current month and the current week.</P><P>For this purpose, I have two additional binary columns (True / False)&nbsp; in the calendar table: Current Month and Current Week.</P><P>The approach above is working with the SELECTEDVALUE and SWITCH function.</P><P>I have created a new table with one column and the two values "MTD" and "WTD" that are referenced in the SELECTEDVALUE Measure.</P><P>How can I add the binary columns Current Month &amp; Week into the SWITCH Function?</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P> Sat, 25 Jul 2020 09:42:01 GMT joshua1990 2020-07-25T09:42:01Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Change-the-Column-or-Measure-Value-in-a-Power-BI-Visual-by/m-p/1249896#M20566 <P>Hello everyone!</P><P>I have seen the fantastic video of RADACAD of how to use a parameter table to filter between some measures.</P><P><A href="https://www.youtube.com/watch?v=_sxLEGRCo28" target="_blank">https://www.youtube.com/watch?v=_sxLEGRCo28</A></P><P>&nbsp;</P><P>This approach is really awesome!</P><P>I need to extend this approach to filter between the current month and the current week.</P><P>For this purpose, I have two additional binary columns (True / False)&nbsp; in the calendar table: Current Month and Current Week.</P><P>The approach above is working with the SELECTEDVALUE and SWITCH function.</P><P>I have created a new table with one column and the two values "MTD" and "WTD" that are referenced in the SELECTEDVALUE Measure.</P><P>How can I add the binary columns Current Month &amp; Week into the SWITCH Function?</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P> Sat, 25 Jul 2020 09:42:01 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Change-the-Column-or-Measure-Value-in-a-Power-BI-Visual-by/m-p/1249896#M20566 joshua1990 2020-07-25T09:42:01Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Change-the-Column-or-Measure-Value-in-a-Power-BI-Visual-by/m-p/1250023#M20569 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="92006" data-lia-user-login="joshua1990" class="lia-mention lia-mention-user">joshua1990</a>&nbsp;- Sample data would help me visualize what is going on. This might help:&nbsp;<A href="https://community.powerbi.com/t5/Quick-Measures-Gallery/Dynamic-EVERYTHING-measures-axis-legend-titles-chart-types/m-p/1027881#M444" target="_blank">https://community.powerbi.com/t5/Quick-Measures-Gallery/Dynamic-EVERYTHING-measures-axis-legend-titles-chart-types/m-p/1027881#M444</A></P> <P>&nbsp;</P> <P>This might be a Disconnected Table Trick. If that is the case see this article: <A href="https://community.powerbi.com/t5/Community-Blog/Solving-Attendance-with-the-Disconnected-Table-Trick/ba-p/279563" target="_blank">https://community.powerbi.com/t5/Community-Blog/Solving-Attendance-with-the-Disconnected-Table-Trick/ba-p/279563</A></P> Sat, 25 Jul 2020 13:53:05 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Change-the-Column-or-Measure-Value-in-a-Power-BI-Visual-by/m-p/1250023#M20569 Greg_Deckler 2020-07-25T13:53:05Z