Forum Discussion

JuliaDRX's avatar
JuliaDRX
Regular Visitor
4 years ago
Solved

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's avatar
    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

SpartaBI's avatar
SpartaBI
Icon for Community Champion rankCommunity Champion
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