Group customers in 5 groups by Sales Amount - measure

[piotr_gor]

Hi, 

I have Sales and Customers table. I want to assign group from 1 to 5 to 'Customers'[Name] based on [Sales Amount]. The thing is I want it to responsive ( so calculated columns are no-no ) , so if I filter data by 'Customers'[Type] I'll see scores from 1 to 5 only applied to Customers in selected Type. 

Later I want to use those groups on bar chart to see how many customers are assigned to that group. 

I've created seperate table starting from 1 to 5 to use it on visual and tried to write some code to make it work but without success. 

Can anyone help? 

[PhilipTreacy]

@piotr_gor 

https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/td-p/144...

Regards

Phil