Forum Discussion

GINMED's avatar
GINMED
Helper III
4 years ago
Solved

Get data from another pivoted table

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!

 

 

 

 

 

 

Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

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

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

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