same table lookupvalue multiple values where single value was expected

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...

SpartaBI

4 years ago

JuliaDRX

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] 
    )
)

Showcase Report – Contoso By SpartaBI

Forum Discussion

same table lookupvalue multiple values where single value was expected

Related content

Expression.SyntaxError: Token ',' expected.

LOOKUPVALUE gives 'A table of multiple values was supplied where a single value was expected.'

LOOKUPVALUE - "A table of multiple values was supplied where a single value was expected"

LOOKUPVALUE with multiple results

LOOKUPVALUE with multiple return values