How to divide a column value by a measure?

[k123]

Hi,

I am trying to create some measures in power bi, where I want to divide each score by the sum of scores for each group

My data looks like following:

I created a meaure to get sum of scores by each group, the measure formula used:

Sum by Group = SUMX(VALUES('Table'[group]), CALCULATE( SUM('Table'[score])))

Now I want to create a measure to divide each score in the score column by its corresponding 'Sum by Group' .

Please let me know. Thanks!

[Anonymous]

you can try

divide(SUM ( Table1[score]),calculate(SUM ( Table1[score]),ALLEXCEPT(TABLE1,Table1[category])))

[Anonymous]

I'm thinking you're looking for a result like this, comparing each value to the total value of that group. You can leverage ALL and EARLIER to get the right context:

Percentage of Group Total = 
DIVIDE(Data[Score],
CALCULATE(
    SUM(Data[Score]),
    FILTER(Data, Data[Group] = EARLIER(Data[Group]))), 0)

[k123]

@Anonymous Is there a way to create a measure instead of a column, like in your solution?

[v-chuncz-msft · Accepted solution]

@k123,

You may refer to the measure below.

Measure =
DIVIDE (
    SUM ( Table1[score] ),
    CALCULATE ( SUM ( Table1[score] ), ALLSELECTED ( Table1[category] ) )
)