Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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
User | Count |
---|---|
102 | |
91 | |
84 | |
77 | |
71 |
User | Count |
---|---|
113 | |
104 | |
100 | |
73 | |
65 |