Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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]))
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
93 | |
77 | |
65 | |
53 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |