Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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!
Solved! Go to Solution.
hi @dax_rach
try like:
Column =
MAXX(
FILTER(
TableName,
TableName[Group]= EARLIER(TableName[Group])
&&TableName[DOMAIN]="YOU"
),
TableName[PERC1]
) * [PERC2]
it worked like:
It worked just as I needed it! Thank you very much!
hi @dax_rach
try like:
Column =
MAXX(
FILTER(
TableName,
TableName[Group]= EARLIER(TableName[Group])
&&TableName[DOMAIN]="YOU"
),
TableName[PERC1]
) * [PERC2]
it worked like:
User | Count |
---|---|
25 | |
12 | |
8 | |
6 | |
6 |
User | Count |
---|---|
26 | |
12 | |
11 | |
9 | |
6 |