https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Combining-two-measures-into-one/m-p/910827#M8692 <P>Use earlier function in your filter section to compare overall row.</P><P>&nbsp;</P><P>But i am not what is your requirement.</P><P>Can you share sample data and expected output?</P><P>&nbsp;</P> Fri, 24 Jan 2020 13:36:03 GMT Anonymous 2020-01-24T13:36:03Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Combining-two-measures-into-one/m-p/910770#M8685 <P>Hi,</P><P>&nbsp;</P><P>Is it possible to combine these two measure into 1? They are working.&nbsp;</P><P>&nbsp;</P><P>Measure 1 to calculate the value for the next day<BR />com_test =<BR />VAR PriorDay = SELECTEDVALUE(table1[date])+1</P><P>RETURN<BR />CALCULATE(<BR />( SUM(table1[gb_total_supply])),<BR />ALL ( table1[date]),<BR />table1[date] = PriorDay<BR />)</P><P>Measure 2 to calculate the diffrence between the next day and today<BR />com_test minus measure1 =<BR />[com_test] - SUM(table1[gb_total_supply])</P> Thu, 30 Jan 2020 08:45:07 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Combining-two-measures-into-one/m-p/910770#M8685 Anonymous 2020-01-30T08:45:07Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Combining-two-measures-into-one/m-p/910827#M8692 <P>Use earlier function in your filter section to compare overall row.</P><P>&nbsp;</P><P>But i am not what is your requirement.</P><P>Can you share sample data and expected output?</P><P>&nbsp;</P> Fri, 24 Jan 2020 13:36:03 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Combining-two-measures-into-one/m-p/910827#M8692 Anonymous 2020-01-24T13:36:03Z