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
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi, ExcelMonke 

Adjust the bucket logic to account for the precision of the calculations. Given the accuracy issue, you may need to expand the conditions in the function a bit to ensure that all possible values fall within a particular bucket.
If the direct relationship is still an issue, consider creating an intermediate table that explicitly maps values to buckets. You can then use this table to establish a clean relationship between the fact table and the bucket table.

 

How to Get Your Question Answered Quickly 

Best Regards

Yongkang Hua

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

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.