Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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.
Solved! Go to 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 , 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
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?
User | Count |
---|---|
131 | |
74 | |
70 | |
58 | |
53 |
User | Count |
---|---|
190 | |
97 | |
67 | |
62 | |
54 |