https://community.fabric.microsoft.com/t5/Developer/Adding-Relations/m-p/28617#M791 <P>You might not need the second table at all. You can create a calculated column in the 1st table, and use the If function to sort out the Price data into the various buckets.</P><P>&nbsp;</P><P>So, the calculated column would go something like,</P><P>&nbsp;</P><PRE>Column = IF(tblSales[Price$]&lt;100, "Less than 100", IF(tblSales[Price$]&lt;200,"100-200",... so on))</PRE><P>You get the idea.</P><P>&nbsp;</P><P>Regards,</P><P>Mi2n</P> Mon, 11 Apr 2016 12:02:19 GMT Mi2n 2016-04-11T12:02:19Z https://community.fabric.microsoft.com/t5/Developer/Adding-Relations/m-p/25234#M705 <P>Hi</P><P>I have 2 tables</P><P>tblSales ([ProductID] , [Price$])</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 250</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;400</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;1800</P><P>you get the idea</P><P>&nbsp;</P><P>tblSalesBracket ([Price$] , [BandRange])</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;[Less Than 100]</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; [Less Than 100]</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 498&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; [400 - 500]</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 499&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; [400 - 500]</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;500&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; [Over 500]</P><P>&nbsp;</P><P>As you can see i can not use relation for the [Price$] field between the 2 tables becasue the tblSalesBracket ends at 500 but in the tblSales i have more that 500</P><P>&nbsp;</P><P>how can i add a relate the 2 fields together, i assume i need to use DAX</P><P>and what happens when i use decimals in the tblSales only what would be the solution</P><P>Thanks</P> Tue, 29 Mar 2016 17:21:46 GMT https://community.fabric.microsoft.com/t5/Developer/Adding-Relations/m-p/25234#M705 SNik 2016-03-29T17:21:46Z https://community.fabric.microsoft.com/t5/Developer/Adding-Relations/m-p/28617#M791 <P>You might not need the second table at all. You can create a calculated column in the 1st table, and use the If function to sort out the Price data into the various buckets.</P><P>&nbsp;</P><P>So, the calculated column would go something like,</P><P>&nbsp;</P><PRE>Column = IF(tblSales[Price$]&lt;100, "Less than 100", IF(tblSales[Price$]&lt;200,"100-200",... so on))</PRE><P>You get the idea.</P><P>&nbsp;</P><P>Regards,</P><P>Mi2n</P> Mon, 11 Apr 2016 12:02:19 GMT https://community.fabric.microsoft.com/t5/Developer/Adding-Relations/m-p/28617#M791 Mi2n 2016-04-11T12:02:19Z