What do you mean by instances and why do we need to create them! What is the purpose of creating one? I repeat this lecture more than 3 times We have to understand what is the difference between an active and inactive relationship & more importantly we have to understand how and when and where to decide (based on what) Thank you but this lecture is a little bit hard to digest please excuse my poor English

Let's say you have two tables, there can be only one active relationship - Sales date from table A with date from Calendar table B. When you filter the sales from the calendar table, the filtering will work on the sales date. But what if you want the calendar table to filter the sales table by shipment date? You can attempt to make another connection, but this connection will be inactive because Power BI allows for only one relationship which is why you will need to use a function called USERELATIONSHIP in your measure to get the right amount

Follow this topic

feras

Last answered:

05 May 2022

Posted on:

05 May 2022

Resolved: when/how to make the right decision, why do we need instances?

in Power BI / Active vs Inactive Relationships

1 answers ( 1 marked as helpful)

Dimitar Shutev

Posted on:

05 May 2022

Helpful answer

Resolved: when/how to make the right decision, why do we need instances?

Submit an answer

related questions