Forum Discussion
Measure changing when column added to matrix
AnthonyH28 Can you share the relationships between all tables involved please? Just to clarify, 'Sales Metrics'[Sales Combined YTD] is a column, correct? Please add that to the same visual with [Percent of Comany] (which is also a column, right? What table is it in?) and see if that helps you see what's going on a bit better, but yes it will be relationships between Sales Metrics and Percent of Company table. My guess is that Dim_Product to Percent of Company is 1 to many with single cross filter direction? This can't talk to/filter Sales Metrics.
'Sales Metrics'[Sales Combined YTD] is another measure. Its actually in both photos, just renamed. That would be the YTD column.
Yes, the relationship is as you described. The DIM_Product is everything at sku level where this new one I made is one level up, at a product level. We have many different skus per product. So yes, from DIM_Product to Percent of Company, its Many to 1 with single cross filter.
Would it be better if I just recreate the table that has the Percent of Sales down at the SKU level so its a 1:1?
AnthonyH28 You don't need to recreate the table, just use RELATED([Percent of Sales]) to add it to the SKU Level. Then use that new calculated column instead. If that doesn't work, share a screenshot of your model view so I can visualize it better not in my head. 😆