topic DAX - Selecting a Table Value in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-Selecting-a-Table-Value/m-p/694722#M653 <P>Hello again,&nbsp;</P><P>&nbsp;</P><P>I've posted a couple of queries today <LI-MESSAGE title="DAX - How to use a Column Value to use in a Measure" uid="694391" url="https://community.powerbi.com/t5/DAX-Commands-and-Tips/DAX-How-to-use-a-Column-Value-to-use-in-a-Measure/m-p/694391#U694391"></LI-MESSAGE>&nbsp; and <LI-MESSAGE title="DAX - Joining Tables and Measures" uid="694557" url="https://community.powerbi.com/t5/DAX-Commands-and-Tips/DAX-Joining-Tables-and-Measures/m-p/694557#U694557"></LI-MESSAGE>&nbsp;and am close to finalising a report - I'd appreceiate some help with my next step.</P><P>&nbsp;</P><P>I now have a table like the below.&nbsp; I would like to calculate Table.Number * Measure.Day % x&nbsp;to give the results in the 'Help Please' column.</P><P>&nbsp;</P><P>Please can someone help me with a query to identify those row values in the Table.Number column?</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><TABLE><TBODY><TR><TD>Table.Date</TD><TD>Table.Salesperson</TD><TD>Table.$ Amount</TD><TD>Table.Number</TD><TD>Measure.Total</TD><TD>Measure.Day %</TD><TD>Help Please</TD></TR><TR><TD>1st Feb</TD><TD>Bob</TD><TD>200</TD><TD>1</TD><TD>1000</TD><TD>20%</TD><TD>0.2</TD></TR><TR><TD>1st Feb</TD><TD>Jessica</TD><TD>200</TD><TD>1</TD><TD>1200</TD><TD>17%</TD><TD>0.166666667</TD></TR><TR><TD>2nd Feb</TD><TD>Bob</TD><TD>300</TD><TD>2</TD><TD>1000</TD><TD>30%</TD><TD>0.6</TD></TR><TR><TD>2nd Feb</TD><TD>Jessica</TD><TD>400</TD><TD>2</TD><TD>1200</TD><TD>33%</TD><TD>0.666666667</TD></TR><TR><TD>3rd Feb</TD><TD>Bob</TD><TD>500</TD><TD>3</TD><TD>1000</TD><TD>50%</TD><TD>1.5</TD></TR><TR><TD>3rd Feb</TD><TD>Jessica</TD><TD>600</TD><TD>3</TD><TD>1200</TD><TD>50%</TD><TD>1.5</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Many thanks</P><P>&nbsp;</P><P>Gritman</P> Mon, 20 May 2019 08:25:50 GMT gritman 2019-05-20T08:25:50Z DAX - Selecting a Table Value https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-Selecting-a-Table-Value/m-p/694722#M653 <P>Hello again,&nbsp;</P><P>&nbsp;</P><P>I've posted a couple of queries today <LI-MESSAGE title="DAX - How to use a Column Value to use in a Measure" uid="694391" url="https://community.powerbi.com/t5/DAX-Commands-and-Tips/DAX-How-to-use-a-Column-Value-to-use-in-a-Measure/m-p/694391#U694391"></LI-MESSAGE>&nbsp; and <LI-MESSAGE title="DAX - Joining Tables and Measures" uid="694557" url="https://community.powerbi.com/t5/DAX-Commands-and-Tips/DAX-Joining-Tables-and-Measures/m-p/694557#U694557"></LI-MESSAGE>&nbsp;and am close to finalising a report - I'd appreceiate some help with my next step.</P><P>&nbsp;</P><P>I now have a table like the below.&nbsp; I would like to calculate Table.Number * Measure.Day % x&nbsp;to give the results in the 'Help Please' column.</P><P>&nbsp;</P><P>Please can someone help me with a query to identify those row values in the Table.Number column?</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><TABLE><TBODY><TR><TD>Table.Date</TD><TD>Table.Salesperson</TD><TD>Table.$ Amount</TD><TD>Table.Number</TD><TD>Measure.Total</TD><TD>Measure.Day %</TD><TD>Help Please</TD></TR><TR><TD>1st Feb</TD><TD>Bob</TD><TD>200</TD><TD>1</TD><TD>1000</TD><TD>20%</TD><TD>0.2</TD></TR><TR><TD>1st Feb</TD><TD>Jessica</TD><TD>200</TD><TD>1</TD><TD>1200</TD><TD>17%</TD><TD>0.166666667</TD></TR><TR><TD>2nd Feb</TD><TD>Bob</TD><TD>300</TD><TD>2</TD><TD>1000</TD><TD>30%</TD><TD>0.6</TD></TR><TR><TD>2nd Feb</TD><TD>Jessica</TD><TD>400</TD><TD>2</TD><TD>1200</TD><TD>33%</TD><TD>0.666666667</TD></TR><TR><TD>3rd Feb</TD><TD>Bob</TD><TD>500</TD><TD>3</TD><TD>1000</TD><TD>50%</TD><TD>1.5</TD></TR><TR><TD>3rd Feb</TD><TD>Jessica</TD><TD>600</TD><TD>3</TD><TD>1200</TD><TD>50%</TD><TD>1.5</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Many thanks</P><P>&nbsp;</P><P>Gritman</P> Mon, 20 May 2019 08:25:50 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-Selecting-a-Table-Value/m-p/694722#M653 gritman 2019-05-20T08:25:50Z