Forum Discussion

GINMED's avatar
GINMED
Icon for Helper III rankHelper 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)'[Dim...
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])

amitchandak's avatar
amitchandak
Icon for Super User rankSuper 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])

  • GINMED's avatar
    GINMED
    Icon for Helper III rankHelper III
    4 years ago

    amitchandak 

    THANK YOU, that works perfectly!

    Have a great weekend!