How do I show multiple Values in a Matrix column one after the other and not alternating?

[waqarqtrz]

I have the following table I am trying to replicate in a Power BI Matrix:

I recognized this involves creating measures such as a measure that ignores any filters from the columnar categories (External, TCPT, TCYT). So I created the $ Total measure for the $s:as follows:

$ Total = sum('TMO'[Txn_Amt_Balance])

When I add this measure to the values as follows:

I get it alternating under each column, whereas I just want it at the end of the column so that I can add another measure right after that has the percentage of the total based on a specific category per my first screenshot:

[Jai-Rathinavel · Accepted solution]

Hi @waqarqtrz , To achieve the output like in excel you have to remove Participant Grouping L2 field from your Columns section of the matrix and create indivudual measures for External, TCPT, TCYT, TCYT US, Total, Total% and etc... by applying filters inside the measures and pull the measures in Values section of the matrix like below

Sample Output:

Sample Dax for External Measure: (Create other measures for TCPT, TCYT, TCYT US, Total, Total%)

External = CALCULATE(sum('TMO'[Txn_Amt_Balance]),'TMO'[Participant Grouping L2] = "External")

If I answered your question, please mark my post as a solution.

Thanks,

Jai