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] )
nleuck_101
Please try this measure
Count Measure =
VAR T1 =
SUMMARIZE (
TableName,
TableName[Level],
"@Count", SUMX ( VALUES ( TableName[Count] ), TableName[Count] )
)
RETURN
SUMX ( T1, [@Count] )
tamerj1
Thank you! This solution worked as expected.