Create calculated column assigning value from another colum|n to all rows from the same group.

[dax_rach]

Hi everyone!

I'm trying to come up with a solution for this issue. I need to create a calculated column [NEEDED_COL] that has a value which is in a different column [PERC_1]. 

In the example, I am trying to achieve this result. There are over 50.000 different values on [GROUP] and each one has a row [DOMAIN| = "YOU" with its corresponding [PERC_1]value. The calculated column [NEEDED_COL] needs for each row of each group to have that [PERC_1] that belongs to the row = "YOU"

GROUP	DOMAIN	PERC_1	PERC_2	NEEDED_COL ( PERC_1 = "YOU"	RESULT_COL ( PERC_2 x NEEDED_COL )
Group_1	website_1	50%	13%	35%	13% x 35%
Group_1	test_web	20%	3%	35%	3 x 35%
Group_1	YOU	35%	6%	35%	6% x 35%
Group_20	website_thing	12%	3%	11%	3% x 11%
Group_20	YOU	11%	33%	11%	33% x 11%
Group_20	wwwtestcom	18%	6%	11%	6% x 11%
Group_500	europe.web	65%	7%	33%	7% x 33%
Group_500	curry_tag	4%	87%	33%	87% x 33%
Group_500	YOU	33%	44%	33%	44% x 33%

Many thanks!

[dax_rach]

It worked just as I needed it! Thank you very much! 

[FreemanZ · Accepted solution]

hi @dax_rach 

try like:

Column = 
MAXX(
    FILTER(
        TableName,
        TableName[Group]= EARLIER(TableName[Group])
            &&TableName[DOMAIN]="YOU"
    ),
    TableName[PERC1]
) * [PERC2]

it worked like: