Calculate value as percentage of column average

[essjayemm]

I'm attempting to represent some table values as a percentage of the column average as follows:

Branch	Quantity	Quantity as % of Ave. Quantity
1	205,985.023	59.23%
2	271,534.925	78.08%
3	336,876.443	96.87%
4	525,621.254	151.15%
5	367,018.183	105.54%
6	649,992.331	186.92%
7	101,413.518	29.16%
8	323,528.034	93.04%
Total	2,781,969.711

The quantity value for each branch is correctly calculated using a measure but I cannot get the correct DAX calculation to determine the values shown in the Quantity as % of Ave. Quantity column.  I can correctly calculate the average (347,746.21) as a separate measure but when I drop a new measure of Quantity / Average the row result is not correct.

I have the individual branch value as a % of column total correctly calculated but feel I am now over-thinking what I need to do to achieve the solution I'm after.

[parry2k · Accepted solution]

@essjayemm you avg qty measure should be this:

Avg Qty = CALCULATE ( AVERAGE ( 'Table'[Quantity] ), ALLSELECTED() )

change ALLSELECTED to ALL if you don't want any slicer/filter rows to be removed from the average and from here rest of the calculation should be easy.

Check my latest blog post Compare Budgeted Scenarios vs. Actuals I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

[essjayemm]

Thanks @parry2k.  Your advice and guidance certainly gave me a good shove in the right direction, allowing me to solve my problem.