How to sum matrix header based on category

[Harry_Tran]

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!

[Harry_Tran]

@amitchandak 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.

[amitchandak]

@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/1...
https://community.powerbi.com/t5/Quick-Measures-Gallery/The-New-Hotness-Custom-Matrix-Hierarchy/m-p/...

vote for Hybrid Table
https://ideas.powerbi.com/ideas/idea/?ideaid=9bc32b23-1eb1-4e74-8b34-349887b37ebc