cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Frequent Visitor

## Facing Difficulty in configuring Percentage as well as Total on Matrix Table

I need to create a Matrix Table like below , Please Help me to get this sorted . I am having around 50 column also it is dynamic .

3 REPLIES 3
Frequent Visitor

Any Suggessions or Comments on the above issue

Super User

@Shinooj It's not easy to add an extra "total" row to a matrix or table. You have 2 options. One, you use a disconnected table for your rows and then construct a measure that determines which row you are in and returns the appropriate calculation. Two, you create a measure for each row and use the "Show on rows" feature of the matrix. Sample data would help to be more specific in terms of the solution.

Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.

Become an expert!: Enterprise DNA
External Tools: MSHGQM
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...
Frequent Visitor
 TYPE CREATION_DATE COUNT Track3 01/2023 2 Track 4 03/2023 2 Track1 01/2023 7 Track2 01/2023 34 Track 4 02/2023 1 Track3 03/2023 3 Track1 03/2023 4 Track2 03/2023 9 Track1 02/2023 10 Track3 02/2023 11 Track1 03/2023 51 Track2 03/2023 55 Track1 02/2023 103 Track2 02/2023 111 Track1 01/2023 134 Track2 02/2023 331 Track2 01/2023 862

Text : I need a Resultant Table Like Below with Percentage.

Expected Output

 Row Labels Track 4 Track1 Track2 Track3 (blank) Grand Total 01/2023 141 896 2 1039 02/2023 1 113 442 11 567 03/2023 2 55 64 3 124 (blank) Grand Total 3 309 1402 16 1730 Percentage 0.17% 17.86% 81.04% 0.92% 100.00%