Get the list of sending and receiving agents in two separated filters

[amirabedhiafi]

 I have a fact table and a dimension in my model in Power BI :

ShipmentID SendingAgentCode ReceivingAgentCode

1000            12                            13

1001            14                            15

My model is like below : 

I want to have two filters one for Receiving Agents and one for Sending Agents. How can I achieve that?

Also, I want to calculate the number of shipments for Receiving/Sending Agents separetly.

This is what I tried : 

SendingAgent = LOOKUPVALUE(Agent[AgentCode],Agent[AgentName],Summarize(Shipment,Shipment[SendingAgentCode]))

[amirabedhiafi · Accepted solution]

I ended up creating a separate table :

DimSendingAgent = ALL (DimAgent)

And then created the missing relationship to this new table. This is a common practice for relatively small tables using Power BI.

[Jihwan_Kim]

Hi, @amirabedhiafi 

Please correct me if I wrongly understand your question.

In my opinion, please try to create two relationship lines inactive.

And when you create measures, you can use userelationship function in your measure to calculate per SendingAgent or per ReceivingAgent.

If it is OK with you, please share the sample pbix file, then I can look into it to come up with a more accurate solution.

Thank you.

Jihwan Kim

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

[amirabedhiafi]

I already created two inactive relationships. I can't share the pbix file since it is containing sensitive data.