Forum Discussion
Solved
Distinct SUM
Hi all, I have a table with sales and their goal as per below: Opp Reps Goal 1 Dave 500 2 Dave 500 3 Jane 500 The goal is the same for each rep ( $10...
Try
sumx(summarize(table,table[Reps],"_max",max(Goal)),[_max])
Also refer
https://community.powerbi.com/t5/Desktop/SUM-of-AVERAGE/td-p/197013
Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution.
In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blogs -Decoding Direct Query - Time Intelligence, Winner Coloring on MAP, HR Analytics, Power BI Working with Non-Standard TimeAnd Comparing Data Across Date Ranges
Connect on Linkedin
hi irenelitw629
You may try this formula to create another new measure as below:
New Goal =
SUMX ( VALUES ( 'Table'[Reps] ), [Goal] )
Regards,
Lin