I can't filter my table

[Jc_16]

Hello!

I have 2 tables, totalsales and salesdetails. Both tables are connected by ID using a relation 1(totalsales) to *(salesdetails)

However, I created my mesure "sales" using data in the tablet totalsales due roundings.

When I try to filter my "sales" using some information like products (information in the tablet "salesdetails") it doesn't work.

Can you help me please?

[aditya0125]

change single direction to bi-direction (relation).

[Jc_16]

I did it but the values are not correct. It gives a total value and when I filter by products, the sum of individual products are not the same as total.