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

dax_rach — Mon, 06 Feb 2023 13:47:03 GMT

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!

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

FreemanZ — Mon, 06 Feb 2023 14:11:39 GMT

hi dax_rach

try like:

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

it worked like:

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

dax_rach — Mon, 06 Feb 2023 17:31:44 GMT

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

topic Re: Create calculated column assigning value from another colum|n to all rows from the same group. in DAX Commands and Tips

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

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

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