Dynamic DAX Table with USERELATIONSHIP

[Marco57]

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.

[amitchandak · Accepted solution]

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

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?