waimea

01-08-2019, 03:51 AM

I have crossposted this at mrexcel. https://www.mrexcel.com/forum/power-bi/1082944-relationship-between-tables-doesnt-seem-work-some-values.html

I have a data table and a lookup table but for 2 lookups the values are incorrect and I don't know why? I am calculating the 1-5 and 6-15 measures in the same way that I calculate the rest of the measures that are correct.

In the picture below, the lookups are correct for 0 and all the rest of the lookup values but not for 1-5 and for 6-15?

The correct value for 1-5 should be 4045 and the correct value for 6-15 should be 5235.

The table have a relationship but it seems like the relationship doesn't work for 1-5 and for 6-15?

Could it have something to do with sorting order? All suggestions are welcome.

1-5

6-15

16-19

20-29

30-39

40-49

50-64

65-74

75-79

80-89

90-w

23536

I have a data table and a lookup table but for 2 lookups the values are incorrect and I don't know why? I am calculating the 1-5 and 6-15 measures in the same way that I calculate the rest of the measures that are correct.

In the picture below, the lookups are correct for 0 and all the rest of the lookup values but not for 1-5 and for 6-15?

The correct value for 1-5 should be 4045 and the correct value for 6-15 should be 5235.

The table have a relationship but it seems like the relationship doesn't work for 1-5 and for 6-15?

Could it have something to do with sorting order? All suggestions are welcome.

1-5

6-15

16-19

20-29

30-39

40-49

50-64

65-74

75-79

80-89

90-w

23536