Forum Discussion
Solved
Why does this measure work?
This is more of a "Why does this work" question rather than a "how do I" question. Here is some context of the scenario using dummy data: I have a fact table that looks like this: Each...
Hi,
I see the issue here, in AnalysisCodes Table - you have two rows but only one row in Risk Score for each for RiskScoreID. When you calculate the Risk Score Measure in Risk Score, it's taking consideration of only one row. However, you are already getting correct data from
Total Risk Score as the relationship between the two are met. Hence, the measure you are creating for the Risk Score Measure based on the Risk Score table will never match with the other measure if you are not including relationship between the AnalysisCodes table.
Hi,
I see the issue here, in AnalysisCodes Table - you have two rows but only one row in Risk Score for each for RiskScoreID. When you calculate the Risk Score Measure in Risk Score, it's taking consideration of only one row. However, you are already getting correct data from
Total Risk Score as the relationship between the two are met. Hence, the measure you are creating for the Risk Score Measure based on the Risk Score table will never match with the other measure if you are not including relationship between the AnalysisCodes table.
Ah I see, that makes sense. Thanks a lot