One to Many relationship filtering issue

[PMEH]

Hi 
Can somesome please help me with filtering with Many to one relationship. Here is my data model. 
HP table is in Many to one relation with Inflow/outflow. I need a break down of "TOTAL_ONB" (measurement in Inflow/outflow table) by "PRICING PILLLARS" column in HP table.

Here is the relationship between 2 tables

The filtering works when I do by "PROVINCE" column in HP table, but It does not work when I need to do by "PRICING PILLARS"

This is the correct breakdown

As mentioned above when doing by province, I get the right breakdown.

Any help and guidance will be appreciated. Thank you

[johnt75]

Change both relationships to single direction. Both other tables should filter HP, but HP should not filter the other tables.

[PMEH]

Thanks, tried changing the relationship to one direction. But it does not work. It messess the breakdown by province as well.

[johnt75 · Accepted solution]

You may need to rethink your model. At the moment there is 1 Total ONB value related to many provinces, and I assume pricing pillars. There is no way to tell what portion of the ONB should be attributed to each pricing pillar. Ideally you would have a one-to-many relationship in the other direction so that total ONB is at a lower granularity and you know which part of it belongs to what.