Using Percentage of Grand Total as a Measure

[Anonymous]

Hi, I'm trying to calculate the total weight (61.45%) as a measure, so later I could divide other columns by that value (0.6145). It's similar as having %GT but as a measure for calculations.

Any insights?

Normal Weight%TG Weight

[v-yuta-msft]

@Anonymous ,

You can convert [Weight] from measure to calculate column then create a measure using DAX below:

Grand Total =
SUM ( Table[Weight] )

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

The idea is something like this.

[v-yuta-msft]

@Anonymous ,

Modify calculate column like below:

Grand Total =
CALCULATE (
    SUM ( Table[Weight] ),
    ALLEXCEPT ( Table, Table[Year of Year], Table[Region] )
)

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

For calculating the TOTAL:

Total= (CALCULATE(SUM(Population);ALL(Year)))

Then you create another measure with Population/Total for the weight.

[Anonymous]

The problem with this is that when I try to use it later as a total grand sum, it calculates the SUM ( weight) for each row, and not as a total.

[Greg_Deckler]

Take a look at this Quick Measure, Measure Totals, The Final Word should get you what you need:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907

Obviously your exact requirement is a little different, but the technique described should get you where you want to be.