Forum Discussion

nikos_derv's avatar
nikos_derv
Frequent Visitor
3 years ago
Solved

DISTINCTCOUNT INTO GROUPBY CALCULATED TABLE

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!

Need Help
  • ppm1's avatar
    ppm1
    3 years ago

    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

     

1 Reply

  • ppm1's avatar
    ppm1
    Icon for Solution Sage rankSolution Sage
    3 years ago

    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