Division of columns of different sources

[martti]

I've ran into an issue where division of two columns of different sources does not work as intended.

Source A has customer invoice and source B has time spent on the clients. Source A customer names are connected many-to-one to the specific customer registry, which is connected one-to-one to main client registry. Source B customer names are connected in the same way, to another specific registry and that to main client registry.

I made a measure (SUM(invoice_sum)/SUM(time_spent)), which was to be visualised with the customers in the main registry on the x-axis, but there seems to be a problem with relationships, since the results are 0/infinite. There aren't any duplicates in the main registry, but something is off. Is there anything else I should be paying attention to when calculating between different sources?

[v-lili6-msft · Accepted solution]

hi, @martti 

Try to keep all the cross filter direction is "Both" in manage relationship,

and if possible, please share your sample pbix file for us have a test, that will be a great help.

Best Regards,

Lin