Report Filtering / Aggregation Issue

Hi mmickle23 ,

From your description, there is no active relationship between your two tables, and the data of the two tables cannot be directly filtered,  but indirectly filtered through the third table. If you create the wrong model relationship, it may result in incorrect aggregation.

When evaluating ambiguity, Power BI chooses the filter propagation path according to the following precedence rules. The first rule match determines the path it will follow.

• A path consisting of one-to-many or one-to-one relationships from filter to target. The filter must flow from the "one" side of a relationship to the other side for all relationships along the path.
• A path consisting of one-to-many relationships from filter to an intermediate table followed by many-to-one relationships from intermediate table to target. The filter must flow from the "one" side of a relationship to the "many" side for all one-to-many relationships, and from the "many" side of a relationship to the "one" side of the relationship for many-to-one relationships in the path.
• Any other path, including paths that contain many-to-many relationships.

For more information, please refer to:

Create and manage relationships in Power BI Desktop - Power BI | Microsoft Docs

Model relationships in Power BI Desktop - Power BI | Microsoft Docs

Solution: Please select the correct activate relationship between the two tables and try again.

If you still have questions, please provide us with sample .pbix file after hiding sensitive information.

Best regards,

Yadong Fang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.