https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-would-you-compare-two-columns-in-a-Dax-query-from-different/m-p/1133388#M16863 <P>I meant to create a measure only. How would you write a measure for that ?</P> Mon, 01 Jun 2020 14:00:14 GMT shushank 2020-06-01T14:00:14Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-would-you-compare-two-columns-in-a-Dax-query-from-different/m-p/1133325#M16860 <P>Hi All,</P><P>&nbsp;</P><P>I have one scenesio where I have to compare one dimension table data with another dimension table data in a Dax on live cube hence i cant add any calc column.</P><P>&nbsp;</P><P>For example</P><P>&nbsp;</P><P>Calculate(totalrevenue, A+1 =B)</P><P>This is just an example to illustrate my scenerio.</P><P>&nbsp;</P><P>Thanks</P> Mon, 01 Jun 2020 13:36:13 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-would-you-compare-two-columns-in-a-Dax-query-from-different/m-p/1133325#M16860 shushank 2020-06-01T13:36:13Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-would-you-compare-two-columns-in-a-Dax-query-from-different/m-p/1133366#M16861 <a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="206530" data-lia-user-login="shushank" class="lia-mention lia-mention-user">shushank</a> Well you would need to use a measure then. Mon, 01 Jun 2020 13:49:57 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-would-you-compare-two-columns-in-a-Dax-query-from-different/m-p/1133366#M16861 Greg_Deckler 2020-06-01T13:49:57Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-would-you-compare-two-columns-in-a-Dax-query-from-different/m-p/1133388#M16863 <P>I meant to create a measure only. How would you write a measure for that ?</P> Mon, 01 Jun 2020 14:00:14 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-would-you-compare-two-columns-in-a-Dax-query-from-different/m-p/1133388#M16863 shushank 2020-06-01T14:00:14Z