Distinct SUM of repeated values for Group and Region

[zapppsr]

Hi guys, thanks for taking your time to help me. I always find good answers here.

I need a measure or calculated column that can take one Region, see how many different groups are there and sum the Group% but only one time.


The Group % repeats for product, that's why a simple SUM will not suffice.


You can download a Spreadsheet with the model here.

 

[Matt Allington]

What is the calculation for group %

 

[zapppsr]

Hi, Matt Allington thanks for replying!!

In order to achieve my goal, I got some hints from here

Although, the solution was not complete for my scenario.

He proposed to create 2 measures:

AverageValue:=CALCULATE(AVERAGEX(FILTER(fProducts;[Group %]<>0);[Group %]))

SUMDistinctGroupPR:=CALCULATE(SUMX(DISTINCT(fProducts[Group]); [AverageValue]);ALL(fProducts);VALUES(fProducts[Region]))

The red part I added myself. That way it worked like a charm. Here is the file with solution.