Forum Discussion

kasife's avatar
kasife
Helper V
3 years ago
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?...
Need Help
  • DOLEARY85's avatar
    DOLEARY85
    3 years ago

    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 👍

     
     
DOLEARY85's avatar
DOLEARY85
Resident Rockstar
3 years ago

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 👍

kasife's avatar
kasife
Helper V
3 years ago

DOLEARY85 thank you so much. it worked perfectly