Relationship not working in measures involving two tables

[yoyfreddy]

Hello! I'm building a dashboard to show the unit cost of Airlines for a school project. I created an index table to show which Cost Category are driven by which Operation Statistics.

Here is my measure : Cost/OpStat = DIVIDE('Cost'[Amount measure],'OpStat'[OpStat full Yr],0)
When I apply this measure into a bar chart, with Airline as the Axis, filtering Cost Category = Aircraft Rent. I expect the highlighted bar to represent "Aircraft Rent of Airline AA, divided by AA's No. of aircraft". But it turns out, that bar represents the "Aircraft Rent of Airline AA, divided by all Airline's OpStat (No. of Staff+No. of aircraft+Available Seat Kilometres+...)"

Here are the relations of my table.

Any experts know what have gone wrong? Thanks in advance! The file can be retrieved here PowerBI debug

 

[GlennUK]

Your data does not make sense - in that you have multiple attributes in the same column - which I can only guess is because you want to be able to filter by Cost Category. I mean, is the whole reason for having the data arranged in your bizarre way just because you want to filter on Cost Category?

 

[yoyfreddy]

@GlennUK thanks for your reply.
My intention is to to visualize the [Transaction Amount / Operation Statistic] by Cost Category, Airline, and Date. The original post is just a simplified version of my entire data structure to upload on this forum.
But if the relationship isn't working in that simple structure, it will be more difficult for me to apply all three filters in [Transaction Amount / Operation Statistic] measure correctly.

This is the real relationship diagram, sorry i cannot share that file.

 

[GlennUK]

;@GlennUK thanks for your reply.
My intention is to to visualize the [Transaction Amount / Operation Statistic] by Cost Category, Airline, and Date. The original post is just a simplified version of my entire data structure to upload on this forum.
But if the relationship isn't working in that simple structure, it will be more difficult for me to apply all three filters in [Transaction Amount / Operation Statistic] measure correctly.

This is the real relationship diagram, sorry i cannot share that file.
View attachment 59435

You are still wanting to filter by Cost Category by the sound of it; Is that the case? Do you see that that does not make sense, as different costs logically should appear in different fields?

 

[GlennUK]

Exactly why can't you share the file for a school project?