DISTINCTCOUNT INTO GROUPBY CALCULATED TABLE

[nikos_derv]

Hi all,

I need to create an aggregated table. To do so, i tryed to use GROUPBY, and use nested X-functions like SUMX, COUNTX etc. However, i need to apply a distinct count too. Anyone knows how to do so?

Below you can see my table so far, and in comments the new column i would use if something like DISTICNTCOUNTX existed.

Many thanks in advance!

[ppm1 · Accepted solution]

You could get that with ADDCOLUMNS(SUMMARIZE( ... instead of using GROUPBY. Otherwise, You could probably do it with a nested GROUPBY expression where the inner one includes your player id field.

Pat