Forum Discussion
Relationship between calculated table and Direct Query table not recognized
- 1 year ago
I have discovered that relationships are broken in some way between Direct Query tables and calculated tables, so I am unable to use the calculated table measure as a slicer to filter Direct Query data in the visuals.
While it is possible that converting or duplicating some of the Direct Query tables to Import mode would solve the broken relationship issue, the underlying problem I was trying to solve was to highlight SKU&Subsidiaries incorrectly marked as not replenishable. Since I am having so much trouble with the slicer, I have decided to focus on the more correct solution to this underlying problem, which is to work with the upstream data support teams to fix the source data.
Can you tell me more about how that would work? I can't find anything that explains how to get from the results of INTERSECT to returning TRUE if this row is in the intersect.
ReplenishOnly is a subset of ReplenishAll, so it seems like using INTERSECT on those tables would just return ReplenishOnly again.
Hi shadowsong42,
Could you please provide some sample data so we can offer a solution to your issue?
Thank you