Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Distinct Sum

Hi all ,    I have three columns ,   Month    Amount   Rate Jan           95000        35 Jan             6552        35 Jan             1556       35 Jan           95000       35 Jan       ...
Need Help
  • parry2k's avatar
    parry2k
    6 years ago

    Anonymous try this

     

    Measure = 
DIVIDE ( 
SUMX ( VALUES ( Table[Rate] ), CALCULATE ( MAX ( Table[Amount] ) ) ),
MAX ( Table[Rate] )
)

     

    I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

    ⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡

parry2k's avatar
parry2k
Super User
6 years ago

Anonymous try this

 

Measure = 
DIVIDE ( 
SUMX ( VALUES ( Table[Rate] ), CALCULATE ( MAX ( Table[Amount] ) ) ),
MAX ( Table[Rate] )
)

 

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    parry2k  , thank you.

     

    The measure works when i have a month selected.

    Is there a way to modify the formula to get the sum of all months when no month is selected?

     

    Thanks.

    • parry2k's avatar
      parry2k
      Super User
      6 years ago

      Anonymous it should work in both the scenario, what is not working when no month is selected?