Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
why cant i write VALUES('calendar'[MonthName]) and drag this is a matrix and see the unqiue values of that column. Isnt this function supposed to return the unqiue values of a column within a table?
Solved! Go to Solution.
No. Values function cannot be used directly to return result. It's use is limited as intermediate function, nested within another function.
Ex:
=COUNTROWS(VALUES('calendar'[MonthName]))
If you stick the column into rows of Matrix. It will automatically aggregated/grouped by distinct.
Then you can add measures to summarize data based on it.
Though I'm not sure what end result you are after.
No. Values function cannot be used directly to return result. It's use is limited as intermediate function, nested within another function.
Ex:
=COUNTROWS(VALUES('calendar'[MonthName]))
If you stick the column into rows of Matrix. It will automatically aggregated/grouped by distinct.
Then you can add measures to summarize data based on it.
Though I'm not sure what end result you are after.
User | Count |
---|---|
102 | |
90 | |
80 | |
71 | |
69 |
User | Count |
---|---|
114 | |
100 | |
97 | |
72 | |
68 |