https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-get-max-value-of-two-colums/m-p/4396538#M174554 <P>Anonymous</LI-USER>&nbsp;, Try using</P> <P>DAX<BR />_Max X = <BR />MAXX(<BR />SUMMARIZE(<BR />'YourTable',<BR />'Date'[Year],<BR />'Country'[Region],<BR />"SumQuantity", [Sum Quantity]<BR />),<BR />[SumQuantity]<BR />) * 1.2</P> Wed, 05 Feb 2025 14:35:27 GMT bhanu_gautam 2025-02-05T14:35:27Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-get-max-value-of-two-colums/m-p/4396532#M174553 <P>Hi,<BR /><BR />This is my bar chart.<BR />In the legend the 'Year' (column of Date table), the Y-axis 'Region' (column of Country table), the X-axis 'Sum Quantity'<BR />The bar overlaps sometimes the labels. To prevent that I want to compute a MAX value and compute it with 1.2<BR />This computed measure I will then put in X-axis / Range / Maximum<BR /><img /></P><P>If I wouldn't have a legend, the next measure would work<BR /><BR /></P><DIV><SPAN>_Max X =</SPAN> <SPAN>MAXX</SPAN><SPAN>(</SPAN><SPAN>VALUES</SPAN><SPAN>(</SPAN><SPAN>'Regions'</SPAN><SPAN>[Domestic]</SPAN><SPAN>),</SPAN><SPAN>[Sum Quantity]</SPAN><SPAN>) * </SPAN><SPAN>1.2<BR /><BR />But if I use this measure with the legend, this happens<BR /><BR /><img /><BR /><BR /></SPAN>_Max X becomes (35K + 35K + 16K) * 1.2<BR />But it should become 35K (being the highest value for a single bar) * 1.2<BR /><BR />Of course I have to embed the legend (Year) as well in my measure.<BR />How do I do that?<BR /><BR />Regards<BR />Ron</DIV> Wed, 05 Feb 2025 14:31:58 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-get-max-value-of-two-colums/m-p/4396532#M174553 Anonymous 2025-02-05T14:31:58Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-get-max-value-of-two-colums/m-p/4396538#M174554 <P>Anonymous</LI-USER>&nbsp;, Try using</P> <P>DAX<BR />_Max X = <BR />MAXX(<BR />SUMMARIZE(<BR />'YourTable',<BR />'Date'[Year],<BR />'Country'[Region],<BR />"SumQuantity", [Sum Quantity]<BR />),<BR />[SumQuantity]<BR />) * 1.2</P> Wed, 05 Feb 2025 14:35:27 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-get-max-value-of-two-colums/m-p/4396538#M174554 bhanu_gautam 2025-02-05T14:35:27Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-get-max-value-of-two-colums/m-p/4396616#M174557 <P>Thnx&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="625922" data-lia-user-login="bhanu_gautam" class="lia-mention lia-mention-user">bhanu_gautam</a>&nbsp;, it works</P> Wed, 05 Feb 2025 15:00:45 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-get-max-value-of-two-colums/m-p/4396616#M174557 Anonymous 2025-02-05T15:00:45Z