Group by Percentage Range base Dax added measure based on % measure formula

[Jienie]

Hi all,

I am stuck on this one and need help...

I have brought in my data source from which I have created measures for Actual, Total, and %, and all measures are calculated 100% accurately.  

Within my sales data, I have all Sales staff, with employee numbers and various sites/ provinces the link to

I want to add a measure that provides me with a view that looks something like this... so what I want to be able to see from my individual % achieved is how many individuals have 0%, how many are between 1% to 10%, etc.

Is there a way that I can add a measure in DAX that is based on the current % measure that I have already added in my Power BI model

I will really appreciate the support...

I have looked at this solution in the community "Group by Percentage Range", but this is based on data at the back end and I need to base my formulas on current % measures in my measures table

Hope this makes sense

[johnt75]

Have a look at https://www.daxpatterns.com/dynamic-segmentation/