topic Dax measure duplicating results in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Dax-measure-duplicating-results/m-p/3242868#M119359 <P>Here is a simplified model:</P><P><A title="FRC_0123" href="https://1drv.ms/x/s!AhK8zgM_1Ab0gUzwgjQd6jYL534q?e=fVTRTG" target="_self">https://1drv.ms/x/s!AhK8zgM_1Ab0gUzwgjQd6jYL534q?e=fVTRTG</A>&nbsp;</P><P>Problem: in The Output (same tab name), the value show a sum of all CF and then repeats the value for all dates. I want to only show the CF value for each respective date.</P><P><img /></P><P>&nbsp;</P><P>Data is coming from two tables: summary4 and NewCF2 and the output uses the following measure:&nbsp;</P><P>&nbsp;</P><P><FONT color="#0000FF"><SPAN>=</SPAN><SPAN>calculate</SPAN><SPAN>(-</SPAN><SPAN>sum</SPAN><SPAN>(NewCF2[CFActivity]),</SPAN><SPAN>filter</SPAN><SPAN>(</SPAN></FONT></P><P><FONT color="#0000FF"><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN><SPAN>ALL</SPAN><SPAN>(NewCF2),&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN></FONT></P><P><FONT color="#0000FF"><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN><SPAN>CONTAINS</SPAN><SPAN>(&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN></FONT></P><P><FONT color="#0000FF"><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN><SPAN>VALUES</SPAN><SPAN>(Summary4),Summary4[Portfolio Company],NewCF2[Company])</SPAN><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN></FONT></P><P><FONT color="#0000FF"><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; )</SPAN></FONT></P><P><FONT color="#0000FF"><SPAN>)</SPAN></FONT></P><P>&nbsp;</P><P>&nbsp;</P><P>Please advise.</P><P>Any takers for this problem?</P><P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="39298" data-lia-user-login="AlexisOlson" class="lia-mention lia-mention-user">AlexisOlson</a>&nbsp;any idea here?</P><P>Thanks</P><P>GR</P> Fri, 02 Jun 2023 18:02:59 GMT giordani2000 2023-06-02T18:02:59Z Dax measure duplicating results https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Dax-measure-duplicating-results/m-p/3242868#M119359 <P>Here is a simplified model:</P><P><A title="FRC_0123" href="https://1drv.ms/x/s!AhK8zgM_1Ab0gUzwgjQd6jYL534q?e=fVTRTG" target="_self">https://1drv.ms/x/s!AhK8zgM_1Ab0gUzwgjQd6jYL534q?e=fVTRTG</A>&nbsp;</P><P>Problem: in The Output (same tab name), the value show a sum of all CF and then repeats the value for all dates. I want to only show the CF value for each respective date.</P><P><img /></P><P>&nbsp;</P><P>Data is coming from two tables: summary4 and NewCF2 and the output uses the following measure:&nbsp;</P><P>&nbsp;</P><P><FONT color="#0000FF"><SPAN>=</SPAN><SPAN>calculate</SPAN><SPAN>(-</SPAN><SPAN>sum</SPAN><SPAN>(NewCF2[CFActivity]),</SPAN><SPAN>filter</SPAN><SPAN>(</SPAN></FONT></P><P><FONT color="#0000FF"><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN><SPAN>ALL</SPAN><SPAN>(NewCF2),&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN></FONT></P><P><FONT color="#0000FF"><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN><SPAN>CONTAINS</SPAN><SPAN>(&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN></FONT></P><P><FONT color="#0000FF"><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN><SPAN>VALUES</SPAN><SPAN>(Summary4),Summary4[Portfolio Company],NewCF2[Company])</SPAN><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN></FONT></P><P><FONT color="#0000FF"><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; )</SPAN></FONT></P><P><FONT color="#0000FF"><SPAN>)</SPAN></FONT></P><P>&nbsp;</P><P>&nbsp;</P><P>Please advise.</P><P>Any takers for this problem?</P><P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="39298" data-lia-user-login="AlexisOlson" class="lia-mention lia-mention-user">AlexisOlson</a>&nbsp;any idea here?</P><P>Thanks</P><P>GR</P> Fri, 02 Jun 2023 18:02:59 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Dax-measure-duplicating-results/m-p/3242868#M119359 giordani2000 2023-06-02T18:02:59Z Re: Dax measure duplicating results https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Dax-measure-duplicating-results/m-p/3266150#M120918 <P>Any takers for this problem?</P><P><A href="https://community.fabric.microsoft.com/t5/user/viewprofilepage/user-id/39298" target="_blank">@AlexisOlson</A>&nbsp;any idea here?</P> Fri, 02 Jun 2023 18:03:34 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Dax-measure-duplicating-results/m-p/3266150#M120918 giordani2000 2023-06-02T18:03:34Z