Forum Discussion

JS23's avatar
JS23
Frequent Visitor
1 year ago
Solved

Items disappearing upon filtering/including

Hi, going a bit crazy here, maybe missing the obvious? Situation is as follows:   Salestable with 'Amount' column and 'Customer ID' column Customer table with 'customer ID' column and 'relation na...
Need Help
  • johnt75's avatar
    johnt75
    1 year ago

    Use Performance Analyzer to get the queries both when it works, with the IDs, and when it doesn't with just the customer name. Look at the queries in DAX Query View and compare the __DS0FilterTable variables, see if you can spot the difference.

    Are there any non-ASCII characters in the name that doesn't work ? I'm not sure if text filters work with non-ASCII characters.

johnt75's avatar
johnt75
Icon for Super User rankSuper User
1 year ago

Use Performance Analyzer to get the queries both when it works, with the IDs, and when it doesn't with just the customer name. Look at the queries in DAX Query View and compare the __DS0FilterTable variables, see if you can spot the difference.

Are there any non-ASCII characters in the name that doesn't work ? I'm not sure if text filters work with non-ASCII characters.

JS23's avatar
JS23
Frequent Visitor
1 year ago

The non-ASCII part was the solution!! Appreciated VERY much johnt75 !!! If I wouldn't have blurred my screenshots it would have been obvious for you. Very impressed that you would even think of such a thing as a possible reason. And I have learned smth! Again, appreciated!