Forum Discussion
AnthonyH28
Helper I
5 years agoMeasure changing when column added to matrix
This inquiry is to understand why this measure is being affected by another column being added. I have a list of products with measures for Past Year, Past YTD, YTD and YTD Growth for sales - pret...
AllisonKennedy
Community Champion
5 years agoAnthonyH28 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.