Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
Solved! Go to 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.⚡
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
@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.⚡
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Thanks @parry2k. Your advice and guidance certainly gave me a good shove in the right direction, allowing me to solve my problem.
User | Count |
---|---|
124 | |
108 | |
99 | |
62 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |