Need help on Dax to identift guest has size XL buy a lot

[Hunghiepsi]

Well, in general, I got stuck with Dax in Power Bi

The following pic is there's a guest buying in our store, his size is XL

So i would like to visualize the customer who has XL size has the greatest netsale contribution comparing with other sizes 

I am appreciated for your support. 

Thanks a lot. 

 

[v-zhangti · Accepted solution]

Hi, @Hunghiepsi 

Sample data:

Measure = DIVIDE(SUM('Table'[Sales]),CALCULATE(SUM('Table'[Sales]),ALL('Table')))

Is this the result you expect?

Best Regards,

Community Support Team _Charlotte

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