Help with creating average per Segment

[sam.mckay]

Check out this tutorial here.

This shows you want you need to do to get these into %.

A lot depends on the context of the calculation, but you’re 90% of the way there.

https://blog.enterprisedna.co/2017/10/31/advanced-segmentation-example-using-dax-in-power-bi/

The % bit to this tutorial is at the end.

I also recently answered a similar forum post around this as well.

See below.

Customer ABC analysis

This is an interesting one, but not too difficult. I looks like you have the first part where you need a supporting table here with your groups. I’ll work with an example from the online portal here. I’m presuming you’re using the dynamic grouping formula pattern for this. Something like the below. Profits by Custom Grouping = VAR RankingDimension = VALUES( Customers[Customer Names] ) RETURN CALCULATE( [Total Profits], FILTER( RankingDimension, COUNTROWS( FILTER(…

Thanks
Sam