Grand total using MATRIX Tables

Hi faheem_Latif_BI 

 

According to the default design of Power BI, I am afraid it is impossible to achieve the same style as you expect.

 

So I suggest you try the styles provided by speedramps . Or look for custom visuals.

 

Of course, I can also provide some methods to help you achieve it as much as possible. You can try the following methods:

 

Your data model needs to be of the following form:

 

“Table”

 

 

Click the following button

 

Create measures.

 

TotalUSA = 
CALCULATE(
    SUM('Table'[Value]),
    FILTER(
        ALL('Table'),
        'Table'[Country] = "USA"
    )
)

 

TotalCanada = 
CALCULATE(
    SUM('Table'[Value]),
    FILTER(
        ALL('Table'),
        'Table'[Country] = "Canada"
    )
)

 

Create a calculated column.

 

Total USA, Canada = SUM('Table'[Value])

 

 

Please refer to the following link to modify the matrix format.

 

Solved: Matrix - Hide a column in visual but consider in c... - Microsoft Fabric Community

 

Here is the result.

 

 

Regards,

Nono Chen

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