Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!
Solved! Go to 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
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
User | Count |
---|---|
90 | |
74 | |
67 | |
63 | |
55 |
User | Count |
---|---|
101 | |
92 | |
74 | |
60 | |
59 |