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.
Hi community,
Following is my sample dataset, I want to add a column "Total Sal"(already added in the following snapshot) that is total of distinct salaries of employees. Grouped by Dept, position,empcode.
I have tried few DAX, but nothing is working.
Your help is much appretiated.
Many thanks,
Meena
Solved! Go to Solution.
Another community member could probably improve on this, but I did this by changing the grain of the table, i.e. removing the qualification column and consolidating the duplicates. You can do this in a separate table by referencing the query in Query Editor.
Then you can add in the measure:
Total Departmental Salary = CALCULATE ( SUM ( Salaries[Salary] ), ALLEXCEPT ( Salaries, Salaries[Dept] ) )
Table = SUMMARIZE ( EmpSalary, EmpSalary[Dept], EmpSalary[empcode], EmpSalary[Position], "TotalSal", DISTINCT ( EmpSalary[salary] ) )
Hai Meena.,
Please try this....
Another community member could probably improve on this, but I did this by changing the grain of the table, i.e. removing the qualification column and consolidating the duplicates. You can do this in a separate table by referencing the query in Query Editor.
Then you can add in the measure:
Total Departmental Salary = CALCULATE ( SUM ( Salaries[Salary] ), ALLEXCEPT ( Salaries, Salaries[Dept] ) )
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 |
---|---|
113 | |
97 | |
84 | |
67 | |
60 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |