Custom Matrix Table Total Column

[ronaldbalza2023]

Hi Everyone, I am having difficulty trying to figure out this one. Thanks in advance 🙂

Scenario: I have two measures in a matrix table [1] Gross Profit, [2] Gross Profit %.
Problem: How can I show the [2] Gross Profit % measure ONLY in the total column?

Current:

Desired result: 

Gross Profit

Gross Profit = CALCULATE( IF( [P&L] = 0, BLANK(), COALESCE([P&L],0)))

Gross Profit %

Gross Profit % = DIVIDE( [Total Gross Profit (Journals)], [Total Sales (Journals)], 0 )

[PaulDBrown · Accepted solution]

You can hide the columns by dragging the right column boundary to the left. You will need to turn off word wrap in the formatting options though.

[PaulDBrown · Accepted solution]

You can hide the columns by dragging the right column boundary to the left. You will need to turn off word wrap in the formatting options though.

[ronaldbalza2023]

@PaulDBrown figure this one out already until you mentioned turning off the word wrap which I think is genius! However, are there any instances that it will show up or it will just hide and it will just show up when you actually unhide it? Thanks alot!

[PaulDBrown · Accepted solution]

They should remain hidden unless the user drags the column to reveal it

[ronaldbalza2023]

@PaulDBrown THANK YOU! 🙂

[Greg_Deckler]

@ronaldbalza2023 I created The New Hotness for this problem: The New Hotness (Custom Matrix Hierarchy) - Microsoft Power BI Community

[ronaldbalza2023]

Hi @Greg_Deckler, thanks for taking the time on this. That's a lot of work I'd say for a simple problem (kinda) :D. Appreciated it!