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 together,
i really looking for a good tip for my following problem , it really drives me crazy !!
It is all in the same table - no realtionship needed.
Both columns have multiple values - unique values .
Line 1 is clear, if WWL_FACT_FACT_ID_HOST is empty - please use FACT_ID_Host
Line | FACT_ID_HOST | WWL_FACT_FACT_ID_HOST | that should be the solution | |
1 | 1M | "empty" | 1M | |
2 | 1M | 1N | 1M | |
3 | 1N | 1N | 1M | if this is same please look for not same and use this |
Solved! Go to Solution.
Result =
IF(
Tabelle1[WWL Werk] <> BLANK(),
Tabelle1[Werk Nr. HOST],
VAR _search = Tabelle1[Werk Nr. HOST]
RETURN
CONCATENATEX(
FILTER(
Tabelle1,
Tabelle1[WWL Werk] = _search
),
Tabelle1[Werk Nr. HOST]
)
)
Result =
IF(
Tabelle1[WWL Werk] <> BLANK(),
Tabelle1[Werk Nr. HOST],
VAR _search = Tabelle1[Werk Nr. HOST]
RETURN
CONCATENATEX(
FILTER(
Tabelle1,
Tabelle1[WWL Werk] = _search
),
Tabelle1[Werk Nr. HOST]
)
)
LookupValue does not work - because of multiple values where single expected.
@JuliaDRX
do you want to do a quick zoom to explain and I'll send back a solution file?
User | Count |
---|---|
25 | |
11 | |
7 | |
6 | |
6 |
User | Count |
---|---|
30 | |
13 | |
11 | |
9 | |
6 |