Forum Discussion

Tom_G's avatar
Tom_G
Icon for Helper II rankHelper II
4 years ago
Solved

Average by category measure

I have a table like below.   Shop    Cities                Number of Employees A             New York                         5 B             Paris                                 6 C           ...
Need Help
  • Fowmy's avatar
    Fowmy
    4 years ago

    Tom_G 

    Try this measure:

    Avg Number of Employees per City = 
VAR _CITY = MAX('Table'[City] ) RETURN
CALCULATE(
    AVERAGE('Table'[NumberofEmployees]),
    'Table'[City] = _CITY,
    REMOVEFILTERS('Table') 

)
Fowmy's avatar
Fowmy
Icon for Super User rankSuper User
4 years ago

Tom_G 

Try this measure:

Avg Number of Employees per City = 
VAR _CITY = MAX('Table'[City] ) RETURN
CALCULATE(
    AVERAGE('Table'[NumberofEmployees]),
    'Table'[City] = _CITY,
    REMOVEFILTERS('Table') 

)
Tom_G's avatar
Tom_G
Icon for Helper II rankHelper II
4 years ago

Hi Fowmy thanks for the measure it works well!