Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi community,
I have a table with over a billion of rows. In that table I want to run a measure on the column with the largest cardinality (col1) grouped by a column with lower cardinality (col2).
The measue is like:
Avg Unique Col1 IDs per Col2 IDs =
AVERAGEX ( VALUES ( Table[Col2 ID]), DISTINCTCOUNT(Table[Col1 ID]))
User | Count |
---|---|
130 | |
108 | |
101 | |
67 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |