Tables Relationships Duplicate values in table visualization

[Anonymous]

Hi, I need help to understand what's going on with the relationships between tables.
I have two tickets table from two differents softwares. I getting this information with SQL in Power BI.

I have dCalendar and Details table too.

The Details table brings the url from each client and it's connected to both tickets tables by the Client field. 
The dCalendar also it's connected to both tickets tables by the DataCompleta field.

When a try to put this informations in a table visuals, the values double.

What I'm doing wrong?

PS: The prints informations are in Portuguese.

[Yakob_Logerfo]

I need help, new to Power bi, How can I create relationship between this table? I have to source of data one for DATA # & DATA $, And I have to completed calculated tables for each, how can I work with all tables by crating the relationship between the tables.

[v-eachen-msft]

Hi @Anonymous ,

You could edit the [StartYear] and [EndYear] like the following DAX:

StartYear =
CALCULATE ( MIN ( Data[DataCompleta] ), ALLSELECTED ( Data[DataCompleta] ) )

EndYear =
CALCULATE ( MAX ( Data[DataCompleta] ), ALLSELECTED ( Data[DataCompleta] ) )

[Anonymous · Accepted solution]

Hello @v-eachen-msft 

I try this but it doesn't work. 😕

I try to change the relationship between tables and my problem was partially resolved. The registers don't repeat anymore but the numbers are different comparing individuals values against values of table. Prints down bellow:

Same date and client but the numbers are different.

I updated the new file onthe same link to use as a sample.

I appreciate any help!
  

[v-eachen-msft]

Hi @Anonymous ,

Could you please share your sample data and excepted result to me if you don't have any confidential Information. Please upload your files to One Drive and share the link here.

[Anonymous]

Thanks for your help @v-eachen-msft !
Here is the link with my sample.

https://drive.google.com/open?id=1F8lAv0HxOl4WTD9ert3rrFyEbfd-Rrsf