Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Tables Relationships Duplicate values in table visualization

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 ...
Need Help
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    6 years ago

    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's avatar
v-eachen-msft
Icon for Community Support rankCommunity Support
6 years ago

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

    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!