Forum Discussion
nleuck_101
Continued Contributor
Continued ContributorTotal 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_101Continued Contributor
Continued Contributor
That only get's me the % of grand total. I still need to display the correct employee count in the visual.
tamerj1
Community Champion
Community ChampionThe column @Count should disply the correct employee count!
- nleuck_101
What about showing each level count, the total count (all the level sumed up), and % of grand total by month-year?
- tamerj1
Tou mentioned that you want to create a calculated table. Seems now you are talking about a measure in a table visual. For a measure the count would be
Count Measure = VAR T1 = SUMMARIZE ( TableName, TableName[Level], "@Count", MAX ( TableName[Count] ) ) RETURN SUMX ( T1, [@Count] )- nleuck_101
There is still a problem. If I'm only getting the MAX it's not summing the levels that might have different values. Example level 10 could have 100, 100, 100, 90, 70. What I would want is for it to sum 100 + 90 +70 and show level 10 as 260 and not the max of 100.