Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
5 years ago
Solved

Data ratio

Good night I have two datasets in my BI and for some reason I can't get data realization to work properly. the data comes from a campaign dailler report that is mixed into the site's absence rep...
  • MFelix's avatar
    MFelix
    5 years ago

    Hi,

     

    The problem with your model is that you have a many to many relationship, meaning that you get multiple result from both tables at the same time giving you multiple calculations.

     

    What you need to do is to a dfimension table to relate both tables with unique values in this case the Userfullname and then make the relationship one tro many from that table to the other two.

     

    This should give expected resutl.

MFelix's avatar
MFelix
Super User
5 years ago

Hi,

 

The problem with your model is that you have a many to many relationship, meaning that you get multiple result from both tables at the same time giving you multiple calculations.

 

What you need to do is to a dfimension table to relate both tables with unique values in this case the Userfullname and then make the relationship one tro many from that table to the other two.

 

This should give expected resutl.