Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I am trying to show sum and average on a column in a matrix like the below screenshot. I have done some research but I am not sure is it really achievable or not. I need some guidance. Thank you.
Solved! Go to Solution.
Hi @Kandarp
I do not believe it is possible to have the subtotals show an average AND sum. You can do either or.
There is a workaround. Basically you can create two matrix tables and have one behind the other. Once you set it up, you can offset the one at the back to be further down a bit and use that as the "Average" while the one on top is the "Sum".
Other than that, am not sure it's possible in the same column.
All the best.
Theo 🙂
If I have posted a response that resolves your question, please accept it as a solution to formally close the post.
Also, if you are as passionate about Power BI, DAX and data as I am, please feel free to reach out if you have any questions, queries, or if you simply want to connect and talk to another data geek!
Want to connect?www.linkedin.com/in/theoconias
@Kandarp a pleasure mate! Glad it worked! 🙂
If I have posted a response that resolves your question, please accept it as a solution to formally close the post.
Also, if you are as passionate about Power BI, DAX and data as I am, please feel free to reach out if you have any questions, queries, or if you simply want to connect and talk to another data geek!
Want to connect?www.linkedin.com/in/theoconias
Hi @Kandarp
I do not believe it is possible to have the subtotals show an average AND sum. You can do either or.
There is a workaround. Basically you can create two matrix tables and have one behind the other. Once you set it up, you can offset the one at the back to be further down a bit and use that as the "Average" while the one on top is the "Sum".
Other than that, am not sure it's possible in the same column.
All the best.
Theo 🙂
If I have posted a response that resolves your question, please accept it as a solution to formally close the post.
Also, if you are as passionate about Power BI, DAX and data as I am, please feel free to reach out if you have any questions, queries, or if you simply want to connect and talk to another data geek!
Want to connect?www.linkedin.com/in/theoconias
@Kandarp a pleasure mate! Glad it worked! 🙂
If I have posted a response that resolves your question, please accept it as a solution to formally close the post.
Also, if you are as passionate about Power BI, DAX and data as I am, please feel free to reach out if you have any questions, queries, or if you simply want to connect and talk to another data geek!
Want to connect?www.linkedin.com/in/theoconias
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
89 | |
87 | |
77 | |
69 | |
68 |
User | Count |
---|---|
222 | |
128 | |
117 | |
82 | |
77 |