Forum Discussion

ExcelMonke's avatar
ExcelMonke
Icon for Impactful Individual rankImpactful Individual
2 years ago

Gaps in Relationship Data - Help

Hello, I am having an issue with a relationship between two tables which is based off of a rounded value. I am not quite sure how to fix this or create a work-around. What I am trying to achieve:...
Need Help
ExcelMonke's avatar
ExcelMonke
Icon for Impactful Individual rankImpactful Individual
2 years ago

Thank you for the input. The "bucket" table is actually a standalone table, where the Days Open is a calculated column based on a couple of calculations in the fact table. Will the value-in-between (Value >X && <=Y)clause not capture these results?

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

No.  Calculated Columns and Calculated Tables are calculated only once, during the Semantic Model refresh. They do not react to user filters.