limit column totals in matrix

[Vamshi2020]

Hi All, I have fields like category and country and four measures Discount, Profit, Quantity, Row id. Iam using matrix visual to show this data

Now in column totals i dont want to show all totals and i just want to show Total for Discount and profit and disable quantity and Row id totals. 

Please help me to achieve this.

TIA

[v-alq-msft · Accepted solution]

Hi, @Vamshi2020 

Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.
Table:

You may create measures as below.

Discount measure = SUM('Table'[Discount])
Profit measure = SUM('Table'[Profit])
Quantity measure = 
IF(
    ISINSCOPE('Table'[Category]),
    SUM('Table'[Quantity])
)
Row ID measure = 
IF(
    ISINSCOPE('Table'[Category]),
    SUM('Table'[Row ID])
)

Result:

Best Regards

Allan

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anand24]

Hi @Vamshi2020 ,

There is currently no direct way to achieve your requirement of showing some value totals while hiding some.

You can use the below work-around though:
1. Disable column subtotals in your matrix visualization

2. Create a copy of this matrix visualization, remove column fields(country in your case) and the values(quantity and row ID in your case) you don't want totals of and enable column subtotal in this visualization

3. Send this 2nd visualization to Back of actual matrix visualization and format such that these 2 matrix visualizations appear as one

4. Group both matrix visualizations is required

Reference Image(I have shown only runs total):

Give a thumbs up if this post helped you in any way and mark this post as solution if it solved your query !!!

[amitchandak]

@Vamshi2020 , You have a choice for row and columns not for the measures. For measure/values you do not have that option that

there are few workaround 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