Total sales measure based on ranking locations

[PerAsperaAdAstr]

Hello everyone, looking for help.

I have created a sum of sales (measure), a range (measure) based on total sales per customer.

I created a DimRank table, basically the rating index 1,2,3,4..., Rank buckets 1-100,101-200.... , is an unplpled table.

I'm trying to create a range cube table, sum of sales within each bucket. I have created Measure 3, which allocates the total sum of sales within each bucket (depending on the customer's range).

Range measurement (I have used all() and allselected(), which give me the same result)

is based on each individual's contriction on the total amount of sales.

My resulting table shows the following, which looks at first glance because the range of customers is maintained and their expense amount is allocated to the correct bucket. However, when I delete ID, the range becomes 1, Bucket displays 1-100 (presumably because everyone (as a group) changes to range 1):

Incorrect result (I had to filter the client ID in the filter pane):

However, Measure 3 gives me the total (correct) amount of sales (for the 2 customers I have filtered).

Data model below:

Any help is highly appreciated.

(added more information on 07/09/2020)

[Greg_Deckler]

@PerAsperaAdAstr - See if this helps. https://community.powerbi.com/t5/Quick-Measures-Gallery/To-Bleep-with-RANKX/m-p/1042520#M452

Otherwise, Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.

[amitchandak]

@PerAsperaAdAstr , refer if these can help

https://www.daxpatterns.com/dynamic-segmentation/
https://radacad.com/grouping-and-binning-step-towards-better-data-visualization

https://radacad.com/dynamic-banding-or-grouping-in-power-bi-using-dax-measures-choose-the-size-of-bi...
https://www.credera.com/blog/technology-solutions/creating-aging-report-using-a-user-selected-date-i...