Unable to Filter Visual using Indirect RelationShip

Hi,

Based on your data model and the calculated column you've created, it seems like you want to filter the visual using columns from the "Customer" table. However, the calculated column "CaseFailureSuccess" is defined in the "Cases" table, and direct filtering from the "Customer" table might not work in this case.

To be able to filter the visual using columns from the "Customer" table, you can follow these steps:

1. Create a relationship between the "Cases" table and the "Customer" table: It looks like the relationship already exists, based on the "Many to 1 Single filter Direction" description in your data model.

2. Create a new calculated column in the "Customer" table: Open the "Customer" table in Power BI and create a new calculated column, which references the "CaseFailureSuccess" column from the "Cases" table using the RELATED() function. The RELATED() function will follow the relationship between the two tables and fetch the corresponding value.

CustomerCaseFailureSuccess = RELATED('Cases'[CaseFailureSuccess])

3.Now, you can use the "CustomerCaseFailureSuccess" column from the "Customer" table to filter the visual.

By creating the calculated column in the "Customer" table, you can use it as a filter in your visual, and it will correctly follow the relationships established in your data model.