Forum Discussion

nleuck_101's avatar
nleuck_101
Icon for Continued Contributor rankContinued Contributor
4 years ago
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...
Need Help
  • tamerj1's avatar
    tamerj1
    4 years ago

    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] )
nleuck_101's avatar
nleuck_101
Icon for Continued Contributor rankContinued Contributor
4 years ago

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.

tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
4 years ago

nleuck_101 
You wanted to sum the distinct values of the count. Fore some reason I missed to read this reply. Please check the two solutions provided below for both a measure and a calculated table.