Forum Discussion

ChiaraFru's avatar
ChiaraFru
Regular Visitor
3 years ago
Solved

How to sum by category?

Dear all,   I try to explain my self better I can. I have HR list, I know which people are based in which country and are taking care of cases in particular markets. I have a table with the amoun...
  • Jihwan_Kim's avatar
    Jihwan_Kim
    3 years ago

    Hi,

    I am not sure how your data model looks like, but please try something like below.

     

    expected result measure: =
SUMX (
    DISTINCT ( 'TableName'[Market] ),
    DIVIDE ( [Cases measure], [HeadCount measure] )
)
Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper User
3 years ago

Hi,

I am not sure how your data model looks like, but please try something like below.

 

expected result measure: =
SUMX (
    DISTINCT ( 'TableName'[Market] ),
    DIVIDE ( [Cases measure], [HeadCount measure] )
)
  • ChiaraFru's avatar
    ChiaraFru
    Regular Visitor
    3 years ago

    Thank you so much!