Filter Field Parameter by Field Parameter Values without Calculated Groups

Without creating an extra measure, your current hierarchy filter won’t fully work. You’ll be able to filter Fleet Group, but only one of Route Segment or Route Group will work at a time since they come from the same table and only one relationship can be active.

If you want to avoid using a measure, your options are to create separate dimension tables for Route Segment and Route Group, or add a column in your hierarchy table that uniquely identifies each row in the fact table, like an Index or Record ID. That second option can get messy, especially if you have multiple fact tables.

Either way, even with your current hierarchy table, you’ll likely need to deal with a many-to-many relationship.

Try the attached pbix.