Error in calculation when create relationship with calendar table

[Anonymous]

Hi!

I'm trying to create a relationship between one table (Event date column) to another table (Calendar table, Dates column). But when I create a relationship btw them, the column measure becomes repeated same values (100). I do check the data type, and both are the same. Any idea or suggestion on how to fix it?

This is what I get after active their relationship; 

[Stachu]

Can you add sample tables (in format that can be copied to PowerBI) from your model with anonymised data? Like this (just copy and paste into the post window).

Column1	Column2
A	1
B	2.5

Also - what's the relationship exactly? Single direction, 1 (Calendar ) to many (Event) with Calendar filtering Event? What's the syntax of the measure that has problems?