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...
I have finally found a solution to this problem. I had to copy and paste the term 'Controllers & I/O' from the original Excel file to get the formula to work. Even though the copy-and-pasted string was identical to the typed-in string, the display would only work with the copy-and-pasted string. To clarify, there were no extra characters in the copy-and-pasted string. Earlier I had tried copy and pasting 'Controllers & I/O' from the edit queries page with no success so this solution was a surprise.
