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 👍
Hello
please can you advise how to add a filter to this formula please?
the formula is great but what if i wanted to do based on condition of another column e.eg Rag = "Red"
please can you advise
You could try this:
Total sales = CALCULATE(SUMX(DISTINCT('Table'[Module]),FIRSTNONBLANK('Table'[Sales Value],0)),'Table'[RAG]="Red")
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍