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.⚡

dax's avatar
dax
Community Support
6 years ago

Hi Anonymous , 

You could refer to my sample for details.

Measure 4 = SUMX(SUMMARIZE(T1,T1[Rate],T1[Month],T1[Amount],"distict", AVERAGE(T1[Amount])),[distict])/MIN(T1[Rate])

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.