Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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] ) )
User | Count |
---|---|
93 | |
84 | |
78 | |
75 | |
66 |
User | Count |
---|---|
115 | |
105 | |
93 | |
65 | |
60 |