Forum Discussion
Distinct Sum by
Hello Everyone, I have a report that I am trying to sum invoice totals by the distinct invoice number for that particular purchase order and supplier. For some reason I am unable to get the cor...
Anonymous try this measure
Distinct Sum = SUMX ( VALUES ( Table[Invoice Number] ), CALCULATE ( MAX ( Table[Invoice Amount] ) ) )Check my latest blog post Year-2020, Pandemic, Power BI and Beyond to get a summary of my favourite Power BI feature releases in 2020
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to 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.⚡
Hi parry2k,
Thank you so much!! This seems to be working exactly how I envisioned in my head.
Thank you!