https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Summarize-data-without-counting-duplicates/m-p/3041181#M156616 <P>Hi all-</P><P>&nbsp;</P><P>When I am collopased on matrix view my totals are sumamrizing as intended. My Sumx(Summarize formula worked on one column to not count the duplicated value but does not work on another trying to get the same result.&nbsp;</P><P>&nbsp;</P><P><img /></P><P>&nbsp;</P><P>When expanded the columnwiht 2.9m adds the correct totals. But the 5.4 million column should be around 2.9 milion as well but it is counting the second value.</P><P><img /></P><P>&nbsp;</P><P>&nbsp;</P> Tue, 24 Jan 2023 19:10:26 GMT edavis248 2023-01-24T19:10:26Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Summarize-data-without-counting-duplicates/m-p/3041181#M156616 <P>Hi all-</P><P>&nbsp;</P><P>When I am collopased on matrix view my totals are sumamrizing as intended. My Sumx(Summarize formula worked on one column to not count the duplicated value but does not work on another trying to get the same result.&nbsp;</P><P>&nbsp;</P><P><img /></P><P>&nbsp;</P><P>When expanded the columnwiht 2.9m adds the correct totals. But the 5.4 million column should be around 2.9 milion as well but it is counting the second value.</P><P><img /></P><P>&nbsp;</P><P>&nbsp;</P> Tue, 24 Jan 2023 19:10:26 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Summarize-data-without-counting-duplicates/m-p/3041181#M156616 edavis248 2023-01-24T19:10:26Z