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] )
Hi nleuck_101
Please use
New Table =
VAR T1 =
SUMMARIZE ( TableName, TableName[Level], "@Count", MAX ( TableName[Count] ) )
RETURN
ADDCOLUMNS ( T1, "% Count", DIVIDE ( [@Count], SUMX ( T1, [@Count] ) ) )That only get's me the % of grand total. I still need to display the correct employee count in the visual.
The column @Count should disply the correct employee count!
What about showing each level count, the total count (all the level sumed up), and % of grand total by month-year?
