Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello,
I have this issues. I need to find sum of distinct values in matrix rows.
I have this data:
Imagine this is matrix table and I need to have "Name" in first, then when i hit "+" i get number of letters (Tom 3, Ron 2 ) and when i hit + one more time i get these letters.
Does anyone has any ideas?
Thank you!
Solved! Go to Solution.
@obuolys123 Refer my below screen shot.
@obuolys123 Refer my below screen shot.
The measure for column B would be something like
Distinct Count Of Letters = DISTINCTCOUNT('Table'[Letter])
User | Count |
---|---|
106 | |
86 | |
81 | |
74 | |
71 |
User | Count |
---|---|
112 | |
101 | |
96 | |
74 | |
67 |