Forum Discussion
Solved
Total Employee Count by group
Hello All, I'm trying to calculate calculate total employee count by group so I can get the % of the Grand Total (ex. level 10 employee count is 100 and total employee count is 350 so the % shoul...
nleuck_101
Please try this measureCount Measure = VAR T1 = SUMMARIZE ( TableName, TableName[Level], "@Count", SUMX ( VALUES ( TableName[Count] ), TableName[Count] ) ) RETURN SUMX ( T1, [@Count] )
It's not that easy. The top part is the desired results but the bottom part it what I'm actually getting.