Handle InActive Relation for Chart Values

[Anonymous]

Hi,

I have two tables connected with Date table and also connected each other which ends with one active and another inactive relationship.

Below is my report where I have slicers connected with date table and below visuals in green box comes from the table in active relationship.

Now when I filter the slicers, only the green box visuals are getting updated due to active relationship. How to make the remaining visuals too to get filtered which is having inactive relationship. ?? I know something about function USERELATIONSHIP(), however not sure how to use that in this scenario.

Please help with some detailed explanation or demo.

[Anonymous]

Hi @Anonymous ,

You can refer the content in the following links to use inactive relationship:

Inactive relationships

USERELATIONSHIP in Calculated Columns

using inactive relationship

If the above one is not applicable for you, please some sample data in your model and which fields or measures applied on "the remaining visuals". Please also provide the formula of measure when the visual involve any measure. It is better if you can provide your sample pbix file since it include multiple visuals... Thank you.

Best Regards
Community Support Team _ Rena Ruan
If this post helps, then please consider Accept it as the solution to help the other members find it more.