Calcualted column from two distinct tables

[UditJ]

Hello ,

I am creating a calcualted column which is basically dividing one value by another.  Both the columns are present in two different tables and they are connected via bridge tabes as nothing is common between them. So below is a picture of my data model. The calculation isnt coming up correctly. What may be the possible reasons for it ?  

Calcualtion - The One column is from cross channel table and other column is from benchmark table. Both are basically just getting divided. 

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...