Distinct SUM

[kasife]

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] )

[Ahmedx]

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

[kasife]

@Ahmedx thank you so much. it worked perfectly

[DOLEARY85 · Accepted solution]

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 👍

[kasife]

Hi @DOLEARY85 the sum is incorret. 

[DOLEARY85]

Apologies i sent the wrong one, try this instead:

Total sales = SUMX(DISTINCT('Table'[Module]),FIRSTNONBLANK('Table'[Sales Value],0))

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

[Maz_0102]

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

[DOLEARY85]

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 👍

[kasife]

@DOLEARY85 thank you so much. it worked perfectly

[Ashish_Mathur]

Hi,

Share the download link of the PBI file.

[kasife]

Hi @Ashish_Mathur 

The link 

https://ufile.io/lmi0l5jr