https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-Get-In-measures/m-p/2446082#M65639 <DIV><SPAN>Cost = </SPAN><SPAN>CALCULATE</SPAN><SPAN>(</SPAN><SPAN>SUM</SPAN><SPAN>(</SPAN><SPAN>A[Cost]</SPAN><SPAN>),</SPAN><SPAN>FILTER</SPAN><SPAN>(</SPAN><SPAN>A,A</SPAN><SPAN>[Group]</SPAN><SPAN>=</SPAN><SPAN>B[Group]</SPAN><SPAN>))</SPAN></DIV><DIV>&nbsp;</DIV><DIV><SPAN>This my calculated column DAX its giving expected result, I have tried many ways to create this in Measure But I am not able to achive the result by measure.</SPAN></DIV><DIV>&nbsp;Table A</DIV><DIV><TABLE border="1"><TBODY><TR><TD>Group</TD><TD>Cost</TD></TR><TR><TD>A</TD><TD>5</TD></TR><TR><TD>A</TD><TD>5</TD></TR><TR><TD>B</TD><TD>4</TD></TR></TBODY></TABLE></DIV><DIV>&nbsp;</DIV><DIV>Table B&nbsp;</DIV><DIV><TABLE border="1"><TBODY><TR><TD>Group</TD><TD>Cost</TD></TR><TR><TD>A</TD><TD>10</TD></TR><TR><TD>B</TD><TD>4</TD></TR></TBODY></TABLE></DIV><DIV>&nbsp;</DIV><DIV>I want result as Table B, How I achive the above mentioned results using measure</DIV><DIV>&nbsp;</DIV><DIV>&nbsp;</DIV> Fri, 08 Apr 2022 13:12:01 GMT Anonymous 2022-04-08T13:12:01Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-Get-In-measures/m-p/2446082#M65639 <DIV><SPAN>Cost = </SPAN><SPAN>CALCULATE</SPAN><SPAN>(</SPAN><SPAN>SUM</SPAN><SPAN>(</SPAN><SPAN>A[Cost]</SPAN><SPAN>),</SPAN><SPAN>FILTER</SPAN><SPAN>(</SPAN><SPAN>A,A</SPAN><SPAN>[Group]</SPAN><SPAN>=</SPAN><SPAN>B[Group]</SPAN><SPAN>))</SPAN></DIV><DIV>&nbsp;</DIV><DIV><SPAN>This my calculated column DAX its giving expected result, I have tried many ways to create this in Measure But I am not able to achive the result by measure.</SPAN></DIV><DIV>&nbsp;Table A</DIV><DIV><TABLE border="1"><TBODY><TR><TD>Group</TD><TD>Cost</TD></TR><TR><TD>A</TD><TD>5</TD></TR><TR><TD>A</TD><TD>5</TD></TR><TR><TD>B</TD><TD>4</TD></TR></TBODY></TABLE></DIV><DIV>&nbsp;</DIV><DIV>Table B&nbsp;</DIV><DIV><TABLE border="1"><TBODY><TR><TD>Group</TD><TD>Cost</TD></TR><TR><TD>A</TD><TD>10</TD></TR><TR><TD>B</TD><TD>4</TD></TR></TBODY></TABLE></DIV><DIV>&nbsp;</DIV><DIV>I want result as Table B, How I achive the above mentioned results using measure</DIV><DIV>&nbsp;</DIV><DIV>&nbsp;</DIV> Fri, 08 Apr 2022 13:12:01 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-Get-In-measures/m-p/2446082#M65639 Anonymous 2022-04-08T13:12:01Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-Get-In-measures/m-p/2446260#M65651 <P>I think this will work</P><LI-CODE lang="markup">Cost = CALCULATE( SUM('A'[Cost]), TREATAS( VALUES('B'[Group]), 'A'[Group]) )</LI-CODE> Fri, 08 Apr 2022 14:31:30 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-Get-In-measures/m-p/2446260#M65651 johnt75 2022-04-08T14:31:30Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-Get-In-measures/m-p/2448326#M65808 <P>Execellent John, Its working as expected&nbsp;</P> Mon, 11 Apr 2022 04:59:00 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-Get-In-measures/m-p/2448326#M65808 Anonymous 2022-04-11T04:59:00Z