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 possible clue... In the query editor, in a table that combines sales quarter excel spreadsheets, I tried using the replace values dropdown option on the WE_subsegments column to replace "Controllers & I/O" with "Controllers&I/O" as a workaround for this issue. After clicking the apply and close button in the query editor, the "Controllers & I/O" value remained the same in that table. Replaced value shows up in the applied steps field but had no effect. Does this indicate a data source problem or a table relationship problem? Just looking for help diagnosing this issue. PS: The excel spreadsheets are being accessed through One Drive.
