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?example:
Im using the following measure, but the result is incorrect:
SUMX ( DISTINCT (ultimoReaalDivulgado[VGV Venda] ), ultimoReaalDivulgado[VGV Venda] )
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 👍
10 Replies
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.
Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.
https://1drv.ms/u/s!AiUZ0Ws7G26RiHk-scKQgUfACrhQ?e=nqG9Z6
