https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/dax-to-select-max-and-min-values/m-p/3067892#M156671 <P>I have a line chart which will drill down to year, month, week level I need to select min and Max values dynamically from line chart to show it in a card visual. I am able to filter for only week or month with this dax. please help me on this</P><DIV><DIV><SPAN>Asset Utilization % min per week = </SPAN></DIV><DIV><SPAN>MINX</SPAN><SPAN>(</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; </SPAN><SPAN>KEEPFILTERS</SPAN><SPAN>(</SPAN><SPAN>VALUES</SPAN><SPAN>(</SPAN><SPAN>'Dates'</SPAN><SPAN>[week]</SPAN><SPAN>)),</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; </SPAN><SPAN>CALCULATE</SPAN><SPAN>(</SPAN><SPAN>[Asset Utilization %]</SPAN><SPAN>) </SPAN></DIV><DIV><SPAN>)</SPAN></DIV></DIV><P>&nbsp;</P><P><img /></P><P><img /></P><P>&nbsp;</P><P>&nbsp;</P> Wed, 08 Feb 2023 05:52:03 GMT golojuprasanna 2023-02-08T05:52:03Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/dax-to-select-max-and-min-values/m-p/3067892#M156671 <P>I have a line chart which will drill down to year, month, week level I need to select min and Max values dynamically from line chart to show it in a card visual. I am able to filter for only week or month with this dax. please help me on this</P><DIV><DIV><SPAN>Asset Utilization % min per week = </SPAN></DIV><DIV><SPAN>MINX</SPAN><SPAN>(</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; </SPAN><SPAN>KEEPFILTERS</SPAN><SPAN>(</SPAN><SPAN>VALUES</SPAN><SPAN>(</SPAN><SPAN>'Dates'</SPAN><SPAN>[week]</SPAN><SPAN>)),</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; </SPAN><SPAN>CALCULATE</SPAN><SPAN>(</SPAN><SPAN>[Asset Utilization %]</SPAN><SPAN>) </SPAN></DIV><DIV><SPAN>)</SPAN></DIV></DIV><P>&nbsp;</P><P><img /></P><P><img /></P><P>&nbsp;</P><P>&nbsp;</P> Wed, 08 Feb 2023 05:52:03 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/dax-to-select-max-and-min-values/m-p/3067892#M156671 golojuprasanna 2023-02-08T05:52:03Z