Lookupvalue returns blank for some records

[Anonymous]

When I use LOOKUPVALUE, why some of the records are BLANK. It 

LookupValue = LOOKUPVALUE(factMCCyclePlanCHANNEL_d[UQ_CP_Qtr],

factMCCyclePlanCHANNEL_d[UQ_CP_Qtr],factCallDetail_d[UQ_Qtr])

[Anonymous]

Hi @Anonymous ,

The result is depend on the data in the table factMCCyclePlanCHANNEL_d. Could you please provide some sample data in table factMCCyclePlanCHANNEL_d?

Best Regards

[Anonymous]

I did have duplicate values in the table. I managed to resolve it by removing duplicates

[kymramosrpo]

Hello Anonymous & Community,

I encountered a similar thing today.

Mine was returning an empty value after adding this calculated column in the table with unique order IDs:

CalculatedColumnName =

CALCULATE ( 

    COUNTROWS ( 'TableWithMultipleDuplicateOrderIDs' ) ,

    FILTER (
        'TableWithMultipleDuplicateOrderIDs' ,
        'TableWithMultipleDuplicateOrderIDs'[OrderID] = 'TableWithUniqueOrderIDs[OrderID]
            )

    )

*I just wanted to have a column that shows how many rows are there in the other table that have the same order ID.

Plausible cause: The table with multiple duplicate order IDs (the one I was trying to count) had blank/null rows.

Solution: Edit query (of table with duplicate order IDs) > Select the column > Click the down arrow button next to the column name > Click 'Remove Empty' > Click Close & Apply

*You might need to redo the calculated column formula or just copy-paste to refresh it somehow.

[Anonymous · Accepted solution]

Hi @Anonymous ,

Could you please mark your post as Answered since it has been resolved? It will help the others in the community find the solution easily if they face the same problem with you. Thank you.

Best Regards

[amitchandak]

@Anonymous , I doubt missing match between

factMCCyclePlanCHANNEL_d[UQ_CP_Qtr] and  factCallDetail_d[UQ_Qtr]

Check for that.

Also check

refer 4 ways to copy data from one table to another
https://www.youtube.com/watch?v=Wu1mWxR23jU
https://www.youtube.com/watch?v=czNHt7UXIe8