https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Sum-only-columns-selected-by-the-user/m-p/3101799#M156971 <P>Hello all,</P><P>&nbsp;</P><P>I have data set up in the following format:</P><P>&nbsp;</P><TABLE border="0" cellspacing="0" cellpadding="0"><TBODY><TR><TD>ID</TD><TD>A</TD><TD>B</TD><TD>C</TD><TD>D</TD><TD>E</TD></TR><TR><TD>1</TD><TD>0</TD><TD>1</TD><TD>1</TD><TD>1</TD><TD>1</TD></TR><TR><TD>2</TD><TD>1</TD><TD>0</TD><TD>1</TD><TD>0</TD><TD>1</TD></TR><TR><TD>3</TD><TD>0</TD><TD>1</TD><TD>1</TD><TD>0</TD><TD>1</TD></TR><TR><TD>4</TD><TD>0</TD><TD>1</TD><TD>1</TD><TD>1</TD><TD>1</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>I would like to be able to create a user-input filter to use in a measure.&nbsp; For example, if a user selected columns: "A", "B", and "C" then the measure would calculate SUM(A,B,C)/COLUMN E.</P><P>&nbsp;</P><P>Thanks!</P> Mon, 27 Feb 2023 15:21:40 GMT bk2799 2023-02-27T15:21:40Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Sum-only-columns-selected-by-the-user/m-p/3101799#M156971 <P>Hello all,</P><P>&nbsp;</P><P>I have data set up in the following format:</P><P>&nbsp;</P><TABLE border="0" cellspacing="0" cellpadding="0"><TBODY><TR><TD>ID</TD><TD>A</TD><TD>B</TD><TD>C</TD><TD>D</TD><TD>E</TD></TR><TR><TD>1</TD><TD>0</TD><TD>1</TD><TD>1</TD><TD>1</TD><TD>1</TD></TR><TR><TD>2</TD><TD>1</TD><TD>0</TD><TD>1</TD><TD>0</TD><TD>1</TD></TR><TR><TD>3</TD><TD>0</TD><TD>1</TD><TD>1</TD><TD>0</TD><TD>1</TD></TR><TR><TD>4</TD><TD>0</TD><TD>1</TD><TD>1</TD><TD>1</TD><TD>1</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>I would like to be able to create a user-input filter to use in a measure.&nbsp; For example, if a user selected columns: "A", "B", and "C" then the measure would calculate SUM(A,B,C)/COLUMN E.</P><P>&nbsp;</P><P>Thanks!</P> Mon, 27 Feb 2023 15:21:40 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Sum-only-columns-selected-by-the-user/m-p/3101799#M156971 bk2799 2023-02-27T15:21:40Z