Power bi modeling

[Dexter_BI]

Hello community,

I am stuck at the point and tried all possible way to overcome but it does not work.

I have total three tables and two of them are fact table and both are connected with the third table. now when i am filtering the data it is not filtering cause it says there is no relation between fields I tried creating a bridge table but same issue and cannot even use the related fuction to bring related field fom one table fact table to another & also tried using the date table still same result.(each table is connected with the job Id)

this is my model and for calrification please assist me.

Thanks In Advance

[foodd]

Please provide your work-in-progress Power BI Desktop file (with sensitive information removed) that covers your issue or question completely in a usable format (not as a screenshot).

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.

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

This allows members of the Forum to assess the state of the model, report layer, relationships, and any DAX applied.

[kpost]

Note that only one of your connections between each table is an active relationship (solid line) the others are dotted.   Not sure what effect if any you were hoping for, but that might be playing a role.

They are also only filtering in one direction.

What exactly are you trying to filter, what unique fields do you have in each table, etc.

Some more info would help us steer you in the right direction...

I'm no expert but using the info you provided, I'd suggest making a Date table and a Job ID table and then create active connections to each of the 3  tables from those.  Then in your visuals, slicers etc.... use the Date or Job ID from those new tables.


//Mediocre Power BI advice, but it's free!//

[Dexter_BI]

Hello @kpost ,
I tried to create the relation with different field but the result was same so I stick to original data model and yes the relation is moving in the one direction I want to filter data using the name field present in the interview table moreover offer plan is the unique for the offer table, job id is unique for the Jobdefination table and Interview plan is the unique for the interview table.

Thanks for Reply.