Forum Discussion
Solved
Distinct SUM
Hi Guys, I would like to get the distinct sum by project and by module. I have a sales table with several lines, and when I add the value of the project, the result is multiplied. How could I do it?...
Hi,
try this measure:
Total sales = SUMX(DISTINCT('Table'[Module]),MAX('Table'[Sales Value]))If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Hi,
Share the download link of the PBI file.