Weighted (sales) performance

Question

Hi! Could anyone out there help me with this case, please? https://www.pbiusergroup.com/communities/community-home/digestviewer/viewthread?GroupId=547&MessageKey=dfcdebcd-a0dd-4b78-975e-89ddf53b7c4c&CommunityKey=b35c8468-2fd8-4e1a-8429-322c39fe7110&tab=digestviewer&ReturnUrl=%2fpowerbiug%2fcommunities%2fcommunity-home%2fdigestviewer%3fcommunitykey%3db35c8468-2fd8-4e1a-8429-322c39fe7110%26tab%3ddigestviewer

(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 · Answer

Anonymous&nbsp;
&nbsp;
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 · Answer

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

Forum Discussion

Weighted (sales) performance

2 Replies

Related content

Calculating Weighted Sales

Sales performance Report templates

Sales performance dashboard

Sales and Financial Performance

Sales and Financial Performance