topic Passing Max from one parameter to min of another in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Passing-Max-from-one-parameter-to-min-of-another/m-p/3193996#M157046 <P>I'm trying to set up dynamic range slicers based on parameters, I have set up 2 parameters (Vol 1 and vol 2), when the user adjusts the slider in vol 1, the start of the series for vol 2 should adjust based on the max of Vol 1</P><P>&nbsp;</P><P>the first level would be&nbsp;</P><DIV><DIV><SPAN>Vol 1 = </SPAN><SPAN>GENERATESERIES</SPAN><SPAN>(</SPAN><SPAN>0</SPAN><SPAN>, </SPAN><SPAN>20000</SPAN><SPAN>, </SPAN><SPAN>1</SPAN><SPAN>)</SPAN></DIV><DIV>&nbsp;</DIV><DIV><SPAN>Vol 2 = generateseries(max(max vol1) , max(vol1)+20000, 1)</SPAN></DIV><DIV><SPAN>vol 3...</SPAN></DIV><DIV><SPAN>vol 4..&nbsp;</SPAN></DIV><DIV><SPAN>vol 5...</SPAN></DIV><DIV>&nbsp;</DIV><DIV><SPAN><SPAN>i'm able to calculate the min and max in a measure, but unable to pass that value onto the next "level"<BR /></SPAN></SPAN><DIV><DIV><SPAN>Vol 1 Max = </SPAN><SPAN>SELECTEDVALUE</SPAN><SPAN>('Vol 1'[ Vol 1], </SPAN><SPAN>max</SPAN><SPAN>('Vol 1'[Vol 1]))</SPAN></DIV></DIV><SPAN><BR /><BR /></SPAN></DIV></DIV> Tue, 18 Apr 2023 15:10:33 GMT JasonRimkus 2023-04-18T15:10:33Z Passing Max from one parameter to min of another https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Passing-Max-from-one-parameter-to-min-of-another/m-p/3193996#M157046 <P>I'm trying to set up dynamic range slicers based on parameters, I have set up 2 parameters (Vol 1 and vol 2), when the user adjusts the slider in vol 1, the start of the series for vol 2 should adjust based on the max of Vol 1</P><P>&nbsp;</P><P>the first level would be&nbsp;</P><DIV><DIV><SPAN>Vol 1 = </SPAN><SPAN>GENERATESERIES</SPAN><SPAN>(</SPAN><SPAN>0</SPAN><SPAN>, </SPAN><SPAN>20000</SPAN><SPAN>, </SPAN><SPAN>1</SPAN><SPAN>)</SPAN></DIV><DIV>&nbsp;</DIV><DIV><SPAN>Vol 2 = generateseries(max(max vol1) , max(vol1)+20000, 1)</SPAN></DIV><DIV><SPAN>vol 3...</SPAN></DIV><DIV><SPAN>vol 4..&nbsp;</SPAN></DIV><DIV><SPAN>vol 5...</SPAN></DIV><DIV>&nbsp;</DIV><DIV><SPAN><SPAN>i'm able to calculate the min and max in a measure, but unable to pass that value onto the next "level"<BR /></SPAN></SPAN><DIV><DIV><SPAN>Vol 1 Max = </SPAN><SPAN>SELECTEDVALUE</SPAN><SPAN>('Vol 1'[ Vol 1], </SPAN><SPAN>max</SPAN><SPAN>('Vol 1'[Vol 1]))</SPAN></DIV></DIV><SPAN><BR /><BR /></SPAN></DIV></DIV> Tue, 18 Apr 2023 15:10:33 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Passing-Max-from-one-parameter-to-min-of-another/m-p/3193996#M157046 JasonRimkus 2023-04-18T15:10:33Z