Forum Discussion
Helper IIIHow to sum matrix header based on category
Hi Everyone,
I have a matrix as picture below:
Row: Store
Column: Bucket
Value: Count
I Already have bucket for Good, 1, 2, 3, 4, and 5.
What I am trying to do is add new buckets for:
Bad = 1 + 2 + 3 + 4 + 5
Total = Good + Bad
Is there anyway that I could do this in Power BI
Thanks for your time and help!
2 Replies
- amitchandak
Super User
Harry_Tran , Bucket is based on the measure?
If yes, do dynamic sgementaion
Dynamic segmentation -Measure to Dimension conversion: https://youtu.be/gzY40NWJpWQ
if you are looking for a Hybrid display with Matrix Column and measure
https://community.powerbi.com/t5/Community-Blog/Creating-a-custom-or-hybrid-matrix-in-PowerBI/ba-p/1354591
https://community.powerbi.com/t5/Quick-Measures-Gallery/The-New-Hotness-Custom-Matrix-Hierarchy/m-p/963588#M428vote for Hybrid Table
https://ideas.powerbi.com/ideas/idea/?ideaid=9bc32b23-1eb1-4e74-8b34-349887b37ebc 
Harry_Tranamitchandak thanks for your time
I have a column for bucket,
The issue that I have is this bucket do not have "Bad" and "Total", and I try to add "Bad" and "Total" to the Matrix column. I also have an Detail table, what I would like to do is, if I click to a specific number from the bucket, I can filter the Detail table to show only the data from that bucket.
