(PBIX attached) Slice by filter or supplier doesn't reflect in invoiceamount

[Satch]

https://drive.google.com/file/d/0B_7ViRmIIPNgY1F2cUdkRGcxU28/view?usp=sharing

See this pbix ^^

I have connected the tables but when I select the filter value (f.e. supplier or filter), the invoiceamount doesn't  reflect the changes.

Is it because catalog table has many duplicate rows:

Variant 1 to n Catalog n to 1 Filter

and catalog n to 1 supplier

[Vvelarde]

@Satch

Try changing the Cross Filter Direction to Both (In Variant with Catalog Table)

Regards

Victor

Lima - Peru

[Satch]

@Vvelarde

Thanks that worked. Do I need to set "Apply security filter in both directions"?

Am I good to go anyway the way I have set my relations?

[Vvelarde]

@Satch

Your relations look Ok. Only need to see the flow of the filters in your table.

For example:

In your original file, the relation don't be propagate between the tables because the relation between invert and catalog are single. So when you filter using Suppler the flow stop in Catalog. (Many to One Single Direction)

Regards

Victor

Lima - Peru

[Satch]

@Vvelarde

Thanks. Do you mean I have to set relations to "Both" for the other tables as well? Supplier, Category and Filtervalue?

What about "Apply security filter in both directions"?

[Vvelarde · Accepted solution]

@Satch

Depends of the info that you want to display you need to modify your relations. Only in tables that you need the propagation change to both.

About Apply security filter in both directions is not necessary. This is generally use in direct Queries.

Regards

Victor