Filtering the Data using Inactive relationship

[PremaBoddeda]

Hi All,
I have established an active relationship between two tables and arranged inactive relationships and written the measures using UseRelationship, even though the data is not being filtered out. 
Please help
Thanks,

Regards

Prema

[pratyashasamal]

Hi @PremaBoddeda ,

Please try to change the Cross filter direction from single to both in the active relationship if you want to use the inactive relationhip field as a slicer to filter data.

Thanks ,
Pratyasha Samal

Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C

[MAwwad]

To troubleshoot this issue, there are a few things to consider:

1. Ensure that the inactive relationship is established correctly: Make sure that the fields used to create the inactive relationship match the data type, have the same name, and have a unique value for each record.

2. Check the data modeling settings: Ensure that the "Single Active Relationship" option is not selected, so that multiple relationships can be used in a single calculation.

3. Verify the measure used in the visual: Ensure that the measure used in the visual is using the inactive relationship, and not the active relationship. You can verify this by using the USERELATIONSHIP() DAX function in the measure and checking that it is using the correct relationship.

4. Check the filter context: Ensure that the visual is not being filtered by another measure or a slicer that may be affecting the result.

5. Review the data source: Finally, make sure that the data in the two tables being used for the inactive relationship is correct, and there are no missing or duplicate values.

By following these steps, you should be able to resolve the issue and filter the data correctly using an inactive relationship.