Finding top sales customer

[AnkitAgnihotri]

Hi 

Can anyone please solve the below problem?

Identify the Star Performer for the year? based on following conditions

• Sales Orders is more than 5% of total orders
• Contribution to overall revenue is greater than 5%
• Has the highest profitability

I have these columns 

Quantity

SalesmanID

Sales

Profit

Invoice Year

[mangaus1111 · Accepted solution]

Hi @AnkitAgnihotri ,

see my pbi file

https://1drv.ms/u/s!Aj45jbu0mDVJi3RSRsC5tw_T6Fd9?e=EhmrKf

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

[AnkitAgnihotri]

Thank you so much 😊