Calculate average claims of sales location based on selected customer

[GK94]

Hello!
I've been looking for a while but can't seem to find a solution that fixes my problem. 

I need to calculate the average claims of a sales location to use as a benchmark based on the selected customer. I already have a measure that calculates the percentage of claims to sales, but I'm having trouble implementing the location-based benchmark.

I've tried the following:

AVG Claims Location= CALCULATE([Claims%], FILTER(ALL(D_CUSTOMERS), D_CUSTOMERS[LOCATION] = SELECTEDVALUE(D_CUSTOMERS[LOCATION])))

Claims% is the measure I use for the claim ratio.

Every customer is linked to a sales location, so when I filter to customer X I want to calculate the average Claims% for the corresponding sales location.

Thank you in advance and best regards

[amitchandak · Accepted solution]

@GK94 , Try one of the two

AVG Claims Location= CALCULATE([Claims%], FILTER(ALL(D_CUSTOMERS), D_CUSTOMERS[LOCATION] = MAx(D_CUSTOMERS[LOCATION])))

AVG Claims Location= CALCULATE([Claims%], allexcept(D_CUSTOMERS, D_CUSTOMERS[LOCATION] ))

[GK94 · Accepted solution]

Solved it, the formula I tried first worked, I just filtered on the wrong attribute. Stupid mistake on my part. Thank you for your help anyway!

Best regards

[amitchandak · Accepted solution]

@GK94 , Try one of the two

AVG Claims Location= CALCULATE([Claims%], FILTER(ALL(D_CUSTOMERS), D_CUSTOMERS[LOCATION] = MAx(D_CUSTOMERS[LOCATION])))

AVG Claims Location= CALCULATE([Claims%], allexcept(D_CUSTOMERS, D_CUSTOMERS[LOCATION] ))

[GK94]

Thank you @amitchandak ! I've tried both, but unfortunately in both cases it returns the Claim% for the selected customer, not the sales location of the customer. Any idea why that might be?