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 👍

Maz_0102's avatar
Maz_0102
Helper I
2 years ago

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's avatar
    DOLEARY85
    Resident Rockstar
    2 years ago
    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 👍