One more DAX expression to try.  Note that DATATABLE() has some limitations, e.g. TODAY() & NOW() can't be used as values.

Players = DATATABLE(
    "Name",...

• This reply was modified 2 years, 11 months ago by  Sean McLarty.

INCREDIBLEmouse (4/2/2015)

---

Nice article. Good points. And all that Jazz.

But - I was stunned by the use of underscores as source aliases.

cross apply (something) as _

cross apply (somethingelse) as...

I would have used the COLLATE option to force the collation in the stored proc's WHERE clause, e.g.

SELECT Result = 'This fails'

WHERE 'abc' COLLATE SQL_Latin1_General_CP1_CI_AS

...