Remove columns show only totals

[Anonymous]

Hello,

I need to leave only total and remove where the yellow is marked.
Any ideas? 

it's example:

[v-zhangti · Accepted solution]

Hi, @Anonymous 

You can try the following methods.
Sample data:

Measure:

Sum1 = SUM('Table'[Value1])

Sum2 = SUM('Table'[Value2])

This is the view at the beginning

Measure = IF(HASONEVALUE('Table'[Region]),[Sum1],[Sum1]&" "&[Sum2])

Then modify Total's name.

Is this the result you expect?

Best Regards,

Community Support Team _Charlotte

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

[amitchandak]

@Anonymous , need like hybrid display

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#M428

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