topic Is it possible to integrate the constant DAX expression into Power BI in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Is-it-possible-to-integrate-the-constant-DAX-expression-into/m-p/2353585#M59839 <P>Hello, everyone,</P><P>I have the following request.</P><P>&nbsp;</P><P>I have sales (Sales Invoice Line) per salesperson.</P><P>Salesperson has specific goals (Target). Such as Amount in a specific city or Amount to a specific customer.</P><P>&nbsp;</P><P>I would like to maintain the targets for each salesperson in the target table, including the DAX expression.</P><P>&nbsp;</P><P>Is it possible to integrate the constant DAX expression from Excel (Column "DAX Filter" in "Target" table) into Power BI?</P><P>So that I don't have to create a measure per city, but only one measure "Amount City"</P><P>&nbsp;</P><P>Something like this:</P><P>New Measure:</P><P>Amount City = [DAX Filter]</P><P>&nbsp;</P><P>My data model:</P><P><img /></P><P>&nbsp;</P><P>&nbsp;</P><P>Output:</P><P><img /></P><P>Sample Data:</P><P>&nbsp;</P><P>Target</P><TABLE border="1"><TBODY><TR><TD><STRONG>Code</STRONG></TD><TD><STRONG>Type</STRONG></TD><TD><STRONG>Plan</STRONG></TD><TD><STRONG>DAX Filter</STRONG></TD><TD><STRONG>Planned</STRONG></TD><TD><STRONG>Year</STRONG></TD></TR><TR><TD>JR</TD><TD>Amount with Customer + DAX</TD><TD>Amount in City</TD><TD>CALCULATE( [Sum of Amount] , FILTER('Sales Invoice Line' , 'Sales Invoice Line'[City] = "München" ) )</TD><TD>10000</TD><TD>2010</TD></TR><TR><TD>AH</TD><TD>Amount with Customer + DAX</TD><TD>Amount in City</TD><TD>CALCULATE( [Sum of Amount] , FILTER('Sales Invoice Line' , 'Sales Invoice Line'[City] = "Frankfurt a. M." ) )</TD><TD>200</TD><TD>2010</TD></TR><TR><TD>PS</TD><TD>Amount with Customer + DAX</TD><TD>Amount with Customer</TD><TD>CALCULATE( [Sum of Amount] , FILTER('Sales Invoice Line' , 'Sales Invoice Line'[Sell-to Customer No_] = "40000" ) )</TD><TD>1500</TD><TD>2010</TD></TR><TR><TD>AH</TD><TD>Count of</TD><TD>Count of Order in Suisse</TD><TD>&nbsp;</TD><TD>25</TD><TD>2010</TD></TR><TR><TD>JR</TD><TD>Count of</TD><TD>Count of Order in Austria</TD><TD>&nbsp;</TD><TD>20</TD><TD>2010</TD></TR><TR><TD>JR</TD><TD>Count of</TD><TD>Count of Customers in Austria</TD><TD>&nbsp;</TD><TD>50</TD><TD>2010</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Sales Invoice Line</P><TABLE border="1"><TBODY><TR><TD><STRONG>Document No_</STRONG></TD><TD><STRONG>Line No_</STRONG></TD><TD><STRONG>Sell-to Customer No_</STRONG></TD><TD><STRONG>No_</STRONG></TD><TD><STRONG>Amount</STRONG></TD><TD><STRONG>Quantity</STRONG></TD><TD>Salesperson Code</TD><TD>Posting Date</TD><TD>City</TD></TR><TR><TD>103019</TD><TD>10000</TD><TD>40000</TD><TD>8908-W</TD><TD>530,4</TD><TD>3</TD><TD>PS</TD><TD>13.12.2010</TD><TD>Berlin</TD></TR><TR><TD>103019</TD><TD>20000</TD><TD>40000</TD><TD>8916-W</TD><TD>579,6</TD><TD>2</TD><TD>PS</TD><TD>13.12.2010</TD><TD>Berlin</TD></TR><TR><TD>103019</TD><TD>30000</TD><TD>40000</TD><TD>8924-W</TD><TD>536,3</TD><TD>1</TD><TD>PS</TD><TD>13.12.2010</TD><TD>Berlin</TD></TR><TR><TD>VRG1001168</TD><TD>40000</TD><TD>113000</TD><TD>1996-S</TD><TD>2780,46</TD><TD>2</TD><TD>JR</TD><TD>07.06.2010</TD><TD>München</TD></TR><TR><TD>VRG1001328</TD><TD>20000</TD><TD>113000</TD><TD>1928-W</TD><TD>1049,18</TD><TD>2</TD><TD>JR</TD><TD>28.06.2010</TD><TD>München</TD></TR><TR><TD>VRG1000746</TD><TD>20000</TD><TD>113000</TD><TD>1960-S</TD><TD>383,5</TD><TD>2</TD><TD>JR</TD><TD>12.04.2010</TD><TD>München</TD></TR><TR><TD>VRG1001382</TD><TD>10000</TD><TD>113000</TD><TD>1928-W</TD><TD>1049,18</TD><TD>2</TD><TD>JR</TD><TD>05.07.2010</TD><TD>München</TD></TR><TR><TD>VRG1001434</TD><TD>70000</TD><TD>113000</TD><TD>1984-W</TD><TD>1494,78</TD><TD>1</TD><TD>JR</TD><TD>12.07.2010</TD><TD>München</TD></TR><TR><TD>VRG1001434</TD><TD>60000</TD><TD>113000</TD><TD>1980-S</TD><TD>189,11</TD><TD>1</TD><TD>JR</TD><TD>12.07.2010</TD><TD>München</TD></TR><TR><TD>VRG1002255</TD><TD>30000</TD><TD>129000</TD><TD>1968-W</TD><TD>1494,78</TD><TD>1</TD><TD>JR</TD><TD>01.11.2010</TD><TD>München</TD></TR><TR><TD>VRG1002255</TD><TD>20000</TD><TD>129000</TD><TD>1960-S</TD><TD>191,75</TD><TD>1</TD><TD>JR</TD><TD>01.11.2010</TD><TD>München</TD></TR><TR><TD>VRG1002497</TD><TD>20000</TD><TD>129000</TD><TD>1928-S</TD><TD>54,52</TD><TD>1</TD><TD>JR</TD><TD>06.12.2010</TD><TD>München</TD></TR><TR><TD>VRG1002255</TD><TD>10000</TD><TD>129000</TD><TD>1896-S</TD><TD>995,74</TD><TD>1</TD><TD>JR</TD><TD>01.11.2010</TD><TD>München</TD></TR><TR><TD>VRG1002497</TD><TD>10000</TD><TD>129000</TD><TD>1908-S</TD><TD>189,11</TD><TD>1</TD><TD>JR</TD><TD>06.12.2010</TD><TD>München</TD></TR><TR><TD>VRG1002498</TD><TD>10000</TD><TD>127000</TD><TD>1908-S</TD><TD>234</TD><TD>3</TD><TD>GD</TD><TD>06.12.2009</TD><TD>Stuttgart</TD></TR><TR><TD>VRG1008498</TD><TD>10000</TD><TD>127000</TD><TD>1908-W</TD><TD>289,13</TD><TD>2</TD><TD>VR</TD><TD>06.11.2009</TD><TD>Stuttgart</TD></TR><TR><TD>VRG1002454</TD><TD>10000</TD><TD>125000</TD><TD>1908-S</TD><TD>234</TD><TD>3</TD><TD>AH</TD><TD>06.12.2010</TD><TD>München</TD></TR><TR><TD>VRG1001455</TD><TD>10000</TD><TD>114000</TD><TD>1980-S</TD><TD>169,11</TD><TD>1</TD><TD>JR</TD><TD>12.07.2010</TD><TD>Heilbronn</TD></TR><TR><TD>VRG1002219</TD><TD>10000</TD><TD>12200</TD><TD>1968-W</TD><TD>1794,78</TD><TD>1</TD><TD>JR</TD><TD>01.11.2010</TD><TD>Heilbronn</TD></TR><TR><TD>VRG1002875</TD><TD>10000</TD><TD>129000</TD><TD>1908-S</TD><TD>289</TD><TD>4</TD><TD>AH</TD><TD>06.10.2010</TD><TD>Frankfurt a. M.</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>I thank you in advance!</P><DIV>&nbsp;</DIV><DIV class=""><DIV class=""><DIV>&nbsp;</DIV></DIV><DIV class="">&nbsp;</DIV><DIV class=""><DIV class="">&nbsp;</DIV><DIV class="">&nbsp;</DIV></DIV></DIV> Tue, 22 Feb 2022 16:19:25 GMT denxx34 2022-02-22T16:19:25Z Is it possible to integrate the constant DAX expression into Power BI https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Is-it-possible-to-integrate-the-constant-DAX-expression-into/m-p/2353585#M59839 <P>Hello, everyone,</P><P>I have the following request.</P><P>&nbsp;</P><P>I have sales (Sales Invoice Line) per salesperson.</P><P>Salesperson has specific goals (Target). Such as Amount in a specific city or Amount to a specific customer.</P><P>&nbsp;</P><P>I would like to maintain the targets for each salesperson in the target table, including the DAX expression.</P><P>&nbsp;</P><P>Is it possible to integrate the constant DAX expression from Excel (Column "DAX Filter" in "Target" table) into Power BI?</P><P>So that I don't have to create a measure per city, but only one measure "Amount City"</P><P>&nbsp;</P><P>Something like this:</P><P>New Measure:</P><P>Amount City = [DAX Filter]</P><P>&nbsp;</P><P>My data model:</P><P><img /></P><P>&nbsp;</P><P>&nbsp;</P><P>Output:</P><P><img /></P><P>Sample Data:</P><P>&nbsp;</P><P>Target</P><TABLE border="1"><TBODY><TR><TD><STRONG>Code</STRONG></TD><TD><STRONG>Type</STRONG></TD><TD><STRONG>Plan</STRONG></TD><TD><STRONG>DAX Filter</STRONG></TD><TD><STRONG>Planned</STRONG></TD><TD><STRONG>Year</STRONG></TD></TR><TR><TD>JR</TD><TD>Amount with Customer + DAX</TD><TD>Amount in City</TD><TD>CALCULATE( [Sum of Amount] , FILTER('Sales Invoice Line' , 'Sales Invoice Line'[City] = "München" ) )</TD><TD>10000</TD><TD>2010</TD></TR><TR><TD>AH</TD><TD>Amount with Customer + DAX</TD><TD>Amount in City</TD><TD>CALCULATE( [Sum of Amount] , FILTER('Sales Invoice Line' , 'Sales Invoice Line'[City] = "Frankfurt a. M." ) )</TD><TD>200</TD><TD>2010</TD></TR><TR><TD>PS</TD><TD>Amount with Customer + DAX</TD><TD>Amount with Customer</TD><TD>CALCULATE( [Sum of Amount] , FILTER('Sales Invoice Line' , 'Sales Invoice Line'[Sell-to Customer No_] = "40000" ) )</TD><TD>1500</TD><TD>2010</TD></TR><TR><TD>AH</TD><TD>Count of</TD><TD>Count of Order in Suisse</TD><TD>&nbsp;</TD><TD>25</TD><TD>2010</TD></TR><TR><TD>JR</TD><TD>Count of</TD><TD>Count of Order in Austria</TD><TD>&nbsp;</TD><TD>20</TD><TD>2010</TD></TR><TR><TD>JR</TD><TD>Count of</TD><TD>Count of Customers in Austria</TD><TD>&nbsp;</TD><TD>50</TD><TD>2010</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Sales Invoice Line</P><TABLE border="1"><TBODY><TR><TD><STRONG>Document No_</STRONG></TD><TD><STRONG>Line No_</STRONG></TD><TD><STRONG>Sell-to Customer No_</STRONG></TD><TD><STRONG>No_</STRONG></TD><TD><STRONG>Amount</STRONG></TD><TD><STRONG>Quantity</STRONG></TD><TD>Salesperson Code</TD><TD>Posting Date</TD><TD>City</TD></TR><TR><TD>103019</TD><TD>10000</TD><TD>40000</TD><TD>8908-W</TD><TD>530,4</TD><TD>3</TD><TD>PS</TD><TD>13.12.2010</TD><TD>Berlin</TD></TR><TR><TD>103019</TD><TD>20000</TD><TD>40000</TD><TD>8916-W</TD><TD>579,6</TD><TD>2</TD><TD>PS</TD><TD>13.12.2010</TD><TD>Berlin</TD></TR><TR><TD>103019</TD><TD>30000</TD><TD>40000</TD><TD>8924-W</TD><TD>536,3</TD><TD>1</TD><TD>PS</TD><TD>13.12.2010</TD><TD>Berlin</TD></TR><TR><TD>VRG1001168</TD><TD>40000</TD><TD>113000</TD><TD>1996-S</TD><TD>2780,46</TD><TD>2</TD><TD>JR</TD><TD>07.06.2010</TD><TD>München</TD></TR><TR><TD>VRG1001328</TD><TD>20000</TD><TD>113000</TD><TD>1928-W</TD><TD>1049,18</TD><TD>2</TD><TD>JR</TD><TD>28.06.2010</TD><TD>München</TD></TR><TR><TD>VRG1000746</TD><TD>20000</TD><TD>113000</TD><TD>1960-S</TD><TD>383,5</TD><TD>2</TD><TD>JR</TD><TD>12.04.2010</TD><TD>München</TD></TR><TR><TD>VRG1001382</TD><TD>10000</TD><TD>113000</TD><TD>1928-W</TD><TD>1049,18</TD><TD>2</TD><TD>JR</TD><TD>05.07.2010</TD><TD>München</TD></TR><TR><TD>VRG1001434</TD><TD>70000</TD><TD>113000</TD><TD>1984-W</TD><TD>1494,78</TD><TD>1</TD><TD>JR</TD><TD>12.07.2010</TD><TD>München</TD></TR><TR><TD>VRG1001434</TD><TD>60000</TD><TD>113000</TD><TD>1980-S</TD><TD>189,11</TD><TD>1</TD><TD>JR</TD><TD>12.07.2010</TD><TD>München</TD></TR><TR><TD>VRG1002255</TD><TD>30000</TD><TD>129000</TD><TD>1968-W</TD><TD>1494,78</TD><TD>1</TD><TD>JR</TD><TD>01.11.2010</TD><TD>München</TD></TR><TR><TD>VRG1002255</TD><TD>20000</TD><TD>129000</TD><TD>1960-S</TD><TD>191,75</TD><TD>1</TD><TD>JR</TD><TD>01.11.2010</TD><TD>München</TD></TR><TR><TD>VRG1002497</TD><TD>20000</TD><TD>129000</TD><TD>1928-S</TD><TD>54,52</TD><TD>1</TD><TD>JR</TD><TD>06.12.2010</TD><TD>München</TD></TR><TR><TD>VRG1002255</TD><TD>10000</TD><TD>129000</TD><TD>1896-S</TD><TD>995,74</TD><TD>1</TD><TD>JR</TD><TD>01.11.2010</TD><TD>München</TD></TR><TR><TD>VRG1002497</TD><TD>10000</TD><TD>129000</TD><TD>1908-S</TD><TD>189,11</TD><TD>1</TD><TD>JR</TD><TD>06.12.2010</TD><TD>München</TD></TR><TR><TD>VRG1002498</TD><TD>10000</TD><TD>127000</TD><TD>1908-S</TD><TD>234</TD><TD>3</TD><TD>GD</TD><TD>06.12.2009</TD><TD>Stuttgart</TD></TR><TR><TD>VRG1008498</TD><TD>10000</TD><TD>127000</TD><TD>1908-W</TD><TD>289,13</TD><TD>2</TD><TD>VR</TD><TD>06.11.2009</TD><TD>Stuttgart</TD></TR><TR><TD>VRG1002454</TD><TD>10000</TD><TD>125000</TD><TD>1908-S</TD><TD>234</TD><TD>3</TD><TD>AH</TD><TD>06.12.2010</TD><TD>München</TD></TR><TR><TD>VRG1001455</TD><TD>10000</TD><TD>114000</TD><TD>1980-S</TD><TD>169,11</TD><TD>1</TD><TD>JR</TD><TD>12.07.2010</TD><TD>Heilbronn</TD></TR><TR><TD>VRG1002219</TD><TD>10000</TD><TD>12200</TD><TD>1968-W</TD><TD>1794,78</TD><TD>1</TD><TD>JR</TD><TD>01.11.2010</TD><TD>Heilbronn</TD></TR><TR><TD>VRG1002875</TD><TD>10000</TD><TD>129000</TD><TD>1908-S</TD><TD>289</TD><TD>4</TD><TD>AH</TD><TD>06.10.2010</TD><TD>Frankfurt a. M.</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>I thank you in advance!</P><DIV>&nbsp;</DIV><DIV class=""><DIV class=""><DIV>&nbsp;</DIV></DIV><DIV class="">&nbsp;</DIV><DIV class=""><DIV class="">&nbsp;</DIV><DIV class="">&nbsp;</DIV></DIV></DIV> Tue, 22 Feb 2022 16:19:25 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Is-it-possible-to-integrate-the-constant-DAX-expression-into/m-p/2353585#M59839 denxx34 2022-02-22T16:19:25Z Re: Is it possible to integrate the constant DAX expression into Power BI https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Is-it-possible-to-integrate-the-constant-DAX-expression-into/m-p/2353885#M59859 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="223329" data-lia-user-login="denxx34" class="lia-mention lia-mention-user">denxx34</a> , You need to have target table, salesperson, city and date(month/year etc)&nbsp; and that need join with column tables like salesperson, city, and date. same is true sales invoice table</P> Tue, 22 Feb 2022 16:05:25 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Is-it-possible-to-integrate-the-constant-DAX-expression-into/m-p/2353885#M59859 amitchandak 2022-02-22T16:05:25Z Re: Is it possible to integrate the constant DAX expression into Power BI https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Is-it-possible-to-integrate-the-constant-DAX-expression-into/m-p/2355090#M59932 <P>Thanks for your answer, but I don't quite understand what you mean. Can you please explain it in a little more detail?</P> Wed, 23 Feb 2022 07:06:54 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Is-it-possible-to-integrate-the-constant-DAX-expression-into/m-p/2355090#M59932 denxx34 2022-02-23T07:06:54Z Re: Is it possible to integrate the constant DAX expression into Power BI https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Is-it-possible-to-integrate-the-constant-DAX-expression-into/m-p/2360758#M60326 <P>Hi,&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="223329" data-lia-user-login="denxx34" class="lia-mention lia-mention-user">denxx34</a>&nbsp;</P> <P>&nbsp;</P> <P>According to the data you have provided, If there are not many types of cities, it is recommended to write measures separately, because your data is more complex.</P> <P><img /></P> <P>E.g: I see that a sales person in your data may sell more than one city, how to deal with this situation?</P> <P>&nbsp;</P> <P>Best Regards,</P> <P>Community Support Team _Janey</P> <P>&nbsp;</P> Fri, 25 Feb 2022 09:25:09 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Is-it-possible-to-integrate-the-constant-DAX-expression-into/m-p/2360758#M60326 v-janeyg-msft 2022-02-25T09:25:09Z Re: Is it possible to integrate the constant DAX expression into Power BI https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Is-it-possible-to-integrate-the-constant-DAX-expression-into/m-p/2368935#M60721 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="223329" data-lia-user-login="denxx34" class="lia-mention lia-mention-user">denxx34</a>&nbsp; Hello</P> <P>&nbsp;</P> <P>Any updates?&nbsp;Do you still need help?</P> Wed, 02 Mar 2022 03:26:59 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Is-it-possible-to-integrate-the-constant-DAX-expression-into/m-p/2368935#M60721 v-janeyg-msft 2022-03-02T03:26:59Z