Forum Discussion
Helper IIAverage Grand Total Only in Matrix
I'm having an issue getting the result that I want.
Below is a sample of my data. The blue sections are what I am currently getting. I'm trying to achieve a result where the total columns of my matrix (all cells blue) populates the green section. I do not want it to show the columns in red text, but I cannot figure out how to do that without removing word wrap and making those columns as small as I can. I would prefer to not do this if possible.
Is this possible? Or is my only option to remove word wrap and handle it that way?
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.
11 Replies
- Deku
Super User
Jagged hierarchies are not allowed in Power BI, all you can do is make columns 0 width.
- Greg_Deckler
Community Champion
TCatron18 This technique was specifically invented to solve this problem. https://community.fabric.microsoft.com/t5/Quick-Measures-Gallery/The-New-Hotness-Custom-Matrix-Hierarchy/m-p/963588#M428
v-dineshyaCommunity Support
Hi TCatron18 ,
Hi knut12212,
Thank you for reaching out to the Microsoft Community Forum.
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot). Do not include sensitive information. Do not include anything that is unrelated to the issue or question. Please show the expected outcome based on the sample data you provided.
If my response has resolved your query, please mark it as the Accepted Solution to assist others. Additionally, a 'Kudos' would be appreciated if you found my response helpful.
Thank you
TCatron18Here is my sample file - though most of calculations have broken 😒 The expected outcome is what I have provided for the screenshot in the original post.
EDIT: I fixed my sample dataset for the previous calculations that were not working. Still not getting the result I need though, and the one measure [Total Sent AVG] is not working like the others in the total section.
- v-dineshya
Hi TCatron18 ,
Thanks for reaching out to the Microsoft fabric community forum.
I have sent request to access the sample Data, please approve the request.
Thanks and Regards
- v-dineshya
Hi 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- TCatron18
v-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.
