I created a measure using the SumX and Filter functions, see example below. It works for the most part, except for strings with spaces in a certain table named SalesDetail. I figure it's a problem wi...
Another piece of info... This formula works for a table named 'PriceLines' with the column 'ProductSegment' and search term 'Controllers & I/O'. 'PriceLines' is related one way to the table 'SalesDetail'. I've tried changing the relationship to two-way with no effect.
