Slice from a table which has Inactive Relationship

DAX DAX Calculations
1

Hi,
I need help to Filter information based on a table that is connected via an inactive relationship.
My model is a bit complex and some relationships can not be active because of circular relationships.

Attached is a picture of part of the model. Yellow is the inactive relationship that I need to resolve (payableAccount / Account).

My goal is to filter Stock Table base on information in Entity.

image
image967×778 101 KB

To simplify, I am attaching a pbix file with an active relationship to simulate the situation.

Thanks in advance!

Ezequiel
Foro-FilterWithInactiveRelationship.pbix (648.6 KB)

2

Hi @ezenunez

You can use below approach for Inactive relationships to filter the data.

20211126_151715

2 Likes
3

Thank you so much for that detailed answer @Rajesh

We hope this helped you @ezenunez :slight_smile:

If not, how far did you get and what kind of help you need further?

If yes, kindly mark as solution the answer that solved your query.

4

Thanks a lot, Rajesh!
This works quite nicely!