Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have my imported data from Excel called "Peru", in this table i have the list of employees that participate in a program.
Some of the the columns i have in this table contains the managers ID of each employee, the status and the points each have.
I need to create an automatic table from only the ones that are managers (i would only consider the ones that appear in the Manager ID column), and show the status they have and the points each one have.
I tried with this formula but didn't work:
How can i do it??
thanks a lot!!
try this
SUMMARY = SUMMARIZE(CALCULATETABLE(Table1,Table1[DESIGNATION]="Manager"),Table1[NAME],Table1[DESIGNATION],"Sum of Points",SUM(Table1[POINT]))
User | Count |
---|---|
101 | |
90 | |
78 | |
70 | |
69 |
User | Count |
---|---|
110 | |
96 | |
95 | |
74 | |
71 |