Forum Discussion

cqueiroz2222's avatar
cqueiroz2222
Helper I
2 years ago

Many Relationship Between tables

I made the relationship beetween tables (many to many) using COD_CLIENTE, however, when I try to filter two camps (from baseFaturamentoTotal/Area + baseCasos/COD_CLIENTE) the values are getting double.

 

How can I solve it?

 

 

 

APIS and Embedding

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi cqueiroz2222 ,

     

    I suggest you to refer to the offical blog to learn more about many to many relationship.

    For reference: Many-to-many relationship guidance - Power BI | Microsoft Learn

    I think you can try to create a Dimtable which contains unique values to avoide this issue.

     

    Best Regards,
    Rico Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.