Lookup Values from another table

[sarath5140]

Hi,

Please help me in solving the below problem.

I am using the below calculated column to get the values from another table if my current table column matches.

Note :- Both my tables are not related to each other

ActiveIDs = CALCULATE (

FIRSTNONBLANK(ActiveTable[Id],1),

FILTER ( ALL ( ActiveTable ), ActiveTable[SG] = Table[SG] )

)

Also, I have tried another formula,

ActiveIDs = CALCULATE (

CountRows(ActiveTable[Id]),

FILTER ( ALL ( ActiveTable ), ActiveTable[SG] = Table[SG] )

)

Above both dax formulas are working fine in my power bi desktop but when I publish it to the web , I am getting the error like Can't display the Visual error : This error i have seen only from today till yesterday Visual is working fine and it is displaying the results but I am not sure what hapenned suddenly.

Error details :

The query referenced column 'Table'[ActiveIDs] which depends on another column, relationship or measure that is not in a valid state. Additional information: ''.
Please try again later or contact support. If you contact support, please provide these details.

Can anyone help me in resolving this issue

Thanks

[v-piga-msft]

Hi @sarath5140 ,

If it is convenient, could you share some data sample which could reproduce your scenario and your desired output so that we could help further on it.

Best  Regards,

Cherry

[sarath5140 · Accepted solution]

Hi @v-piga-msft,

It got resolved. I didn't use calculate and count rows function and instead used the relationship between two tables and got the desired result.

Thanks for your help.

[Greg_Deckler]

Have you looked at LOOKUPVALUE?