Incorrectly showing the same sales number after filtering

[aashoe]

Hi,

I’m working in Power BI with a data model that has four main tables: Sales, Inventory, Returned Items, and a Day table. The relationships are set up as follows:

• Sales, Returned Items, and Inventory tables are linked by a shared "style" column.
• Day table links to Sales and Returned Items by the "day" column.

The style names aren’t unique, so I used many-to-many cardinality for these connections.

The issue I’m running into is with filtering in visuals: when I apply a style filter to view sales by color, the percentage for each color shows as 100% instead of reflecting the actual distribution. However, this doesn’t happen with other filters, which show percentages correctly. Any tips on resolving this filtering issue? Thank you!

[johnt75]

Delete the relationships based on style. Create a new table which contains all possible styles like

All Styles =
DISTINCT (
    UNION (
        DISTINCT ( 'returned_items'[Style] ),
        DISTINCT ( 'Sales'[Style] ),
        DISTINCT ( 'Inventory'[Style] )
    )
)

Link this table to sales, inventory and returned items in one-to-many single direction relationships, and use the style column from the new table in visuals, slicers etc.

[aashoe]

It's not working 😞

 Did I set anything wrong in the relationship? 

[johnt75]

No, the only potential issue I can see is that the relationship between date and returned items is inactive. Everything else should work OK. 

What behaviour are you seeing ?

[aashoe]

The same issue: every colour is showing 100% when I apply the style filter. 

[johnt75]

What is the definition of the measure that you are using ?