Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
JuliaDRX
Regular Visitor

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

 

Line 1 is clear, if WWL_FACT_FACT_ID_HOST is empty - please use FACT_ID_Host

IF (mdm_v2_factorylist[WWL_FACT_FACT_ID_HOST]="",mdm_v2_factorylist[FACT_ID_HOST], HERE LOOKuPVALUE for LINE 2+3 ??)
 
Line 2 and 3 is my problem : if WWL_FACT_FACT_ID_HOST is not EMPTY and/or  1N=1N same - please look in WWL_FACT_FACT_ID_HOST where FACT_ID_HOST is different and use that one >> 1M
 
Thanks a lot for your help !! 

 

LineFACT_ID_HOSTWWL_FACT_FACT_ID_HOSTthat should be the solution 
11M"empty"1M 
21M1N1M 
31N1N1Mif this is same please look for not same and use this
1 ACCEPTED SOLUTION
SpartaBI
Community Champion
Community Champion

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

 


2022-05-19 17_30_22-Re_ Need help on DAX function with measure vs colu... - Microsoft Power BI Commu.png


Full-Logo11.png

SpartaBI_3-1652115470761.png   SpartaBI_1-1652115142093.png   SpartaBI_2-1652115154505.png

Showcase Report – Contoso By SpartaBI

View solution in original post

3 REPLIES 3
SpartaBI
Community Champion
Community Champion

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

 


2022-05-19 17_30_22-Re_ Need help on DAX function with measure vs colu... - Microsoft Power BI Commu.png


Full-Logo11.png

SpartaBI_3-1652115470761.png   SpartaBI_1-1652115142093.png   SpartaBI_2-1652115154505.png

Showcase Report – Contoso By SpartaBI

JuliaDRX
Regular Visitor

JuliaDRX_0-1659592963803.png

LookupValue does not work - because of multiple values where single expected.

 

SpartaBI
Community Champion
Community Champion

@JuliaDRX 
do you want to do a quick zoom to explain and I'll send back a solution file?

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.