Forum Discussion
Helper IIAverage Grand Total Only in Matrix
Hi TCatron18 ,
Thank you for reaching out to the Microsoft Fabric Community forum.
There is no relationship between Period Table to another Table, we can't create calculated columns. It is not possible to acheive your expected output
I’d recommend submitting this as a feature request in the official Power BI Ideas forum:
https://ideas.fabric.microsoft.com/The Product team actively reviews suggestions there, and if others in the community upvote it, it could be considered for future updates.
I trust this information proves useful. If it does, kindly “Accept as solution” and give it a 'Kudos' to help others locate it easily.
Thank you.
Community SupportHi TCatron18 ,
Thanks for reaching out to the Microsoft fabric community forum.
Create Total Sent , Total users, % usage as calculated columns and place these three fields into columns field in visual settings and create Avg total sent , Avg Total users and Avg % usage as measures and place these three fields into values field in visual settings. Then you can acheive your requirement.
If you find this post helpful, please mark it as an "Accept as Solution" and consider giving a KUDOS. Feel free to reach out if you need further assistance.
Thanks and Regards
Helper IIv-dineshya I'm not sure I am completely following as I'm not able to get the results I'm looking for. Do I reference the calculated columns in my AVG measures, because I am not able to do so.
Do you have the pbix you can send?
- v-dineshya
Hi TCatron18 ,
Thank you for reaching out to the Microsoft Fabric Community forum.
There is no relationship between Period Table to another Table, we can't create calculated columns. It is not possible to acheive your expected output
I’d recommend submitting this as a feature request in the official Power BI Ideas forum:
https://ideas.fabric.microsoft.com/The Product team actively reviews suggestions there, and if others in the community upvote it, it could be considered for future updates.
I trust this information proves useful. If it does, kindly “Accept as solution” and give it a 'Kudos' to help others locate it easily.
Thank you.- v-dineshya
Hi TCatron18 ,
Could you please confirm if you've submitted this as an idea in the Ideas Forum? If so, sharing the link here would be helpful for other community members who may have similar feedback.
As we haven’t heard back from you in a long while, we’re closing this thread. For any further discussions or questions, please start a new thread in the Microsoft Fabric Community Forum — we’ll be happy to assist.
Thank you for being part of the Microsoft Fabric Community.
- TCatron18
v-dineshya Yes, I did submit this as an idea. Here is the link: https://community.fabric.microsoft.com/t5/Fabric-Ideas/Ability-for-Matrix-Total-to-be-Average-vs-Sum/idi-p/4656184
Thanks!!