Forum Discussion

k123's avatar
k123
Frequent Visitor
8 years ago
Solved

How to divide a column value by a measure?

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 su...
Need Help
Show and Tell
  • v-chuncz-msft's avatar
    v-chuncz-msft
    8 years ago

    k123,

     

    You may refer to the measure below.

    Measure =
DIVIDE (
    SUM ( Table1[score] ),
    CALCULATE ( SUM ( Table1[score] ), ALLSELECTED ( Table1[category] ) )
)
Anonymous's avatar
Anonymous
Not applicable
8 years ago

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's avatar
k123
Frequent Visitor
8 years ago

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

  • v-chuncz-msft's avatar
    v-chuncz-msft
    Icon for Community Support rankCommunity Support
    8 years ago

    k123,

     

    You may refer to the measure below.

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