Forum Discussion

Marco57's avatar
Marco57
Helper III
4 years ago
Solved

Dynamic DAX Table with USERELATIONSHIP

Hello,

 

I am creating a DAX table :

 

DAX Table = CALCULATETABLE(DIMENSION_PIVOTED_NOMINAL, USERELATIONSHIP(DIMENSION_PIVOTED_NOMINAL[DIM_PREF_ID], PREFORM_INPUT[PK_ID]))

 

 

I have created an inactive relationship between my above two tables : One to One and with above order, I should have table PREFORM_INPUT filtering my newly created DAX Table as I understand it being created out of DIMENSION_PIVOTED_NOMINAL

 

Unfortuantely that is not the case, any slicer on PREFORM_INPUT is not changing anything on DAX Table rows.

 

Is there any means to have kind of dynamic DAX Table? If they are static, is there any workaround to link columns from created DAX table to our data model? Maybe by adding calculated columns to this DAX Table?

 

Thanks in advance for the support.

Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    Marco57 , A calculated table is not going to use any slicer filter.  Not you are taking any column from another table. So I doubt this going to make any difference in calculation

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    Marco57 , A calculated table is not going to use any slicer filter.  Not you are taking any column from another table. So I doubt this going to make any difference in calculation

    • Marco57's avatar
      Marco57
      Helper III
      4 years ago

      Thank you for your support @amitchandak 

      So there is no means to create even static DAX table but still having a relationship with a real table?

      Could I add a related column/measure into that DAX table so I could filter on maybe?