Weighted (sales) performance

[Anonymous]

Hi! Could anyone out there help me with this case, please? https://www.pbiusergroup.com/communities/community-home/digestviewer/viewthread?GroupId=547&MessageK...

(Posted first at PUG, just inserted the link to the description of the case here).

Thanks in advance!

Best regards

Torgeir Sesseng, Norway

[v-chuncz-msft]

@Anonymous 

You may take a look at the posts below.

• https://community.powerbi.com/t5/Desktop/Weighted-Average-by-person-and-task-by-date/m-p/942496#M451614
• https://community.powerbi.com/t5/Desktop/Sum-of-values-in-a-measure-with-divide-measure/m-p/296768#M130947

[Anonymous]

Thank you! I came closer with SUMMARIZE, but now I'm struggling to get correct Totals. Row by row the result is ok, but not in total. If I summarize vertically (eg. in Excel) I've got the correct answer...

I'm have to post a new one