Get data from another pivoted table

[GINMED]

Hi, 

I tried to get data from onother table (there is not relationship between them) with such measure-

PROJEKTS_DIM =

LOOKUPVALUE(

'DimensionSetEntry (3)'[PROJEKTS],

'DimensionSetEntry (3)'[Dimension_Set_ID],GL_Entry[Dimension_Set_ID],"-")

But seems like it doesn't work correctly, maybe, becouse it takes first of entries with same ID which is empty.

Please give me some advise - how to get correct data.

Many thanks in advance!

[amitchandak · Accepted solution]

@GINMED , Try a new column like

Maxx(filter('DimensionSetEntry (3)', 'DimensionSetEntry (3)'[Dimension_Set_ID] = GL_Entry[Dimension_Set_ID] && not(isblank('DimensionSetEntry (3)'[PROJEKTS])) ),'DimensionSetEntry (3)'[PROJEKTS])

[GINMED]

@amitchandak 

THANK YOU, that works perfectly!

Have a great weekend!