Grand total using MATRIX Tables

[faheem_Latif_BI]

Hi Life savers,

here is the my case i need a grand total using MATRIX table of my row, Pease help me.

im able to get totals of USD and Canada , but unable to get grand total of both. that is (15+25)=40 in last column

[Anonymous · Accepted solution]

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.

[PaulDBrown]

See if this helps:

Creating a custom matrix 

[faheem_Latif_BI]

Thanks for the reply, but i need a same out put as i provided in image 

[speedramps]

Try either of these methods.

Then please click the thumbs buttom up for the idea,

and also click Accept Solution if it works.

Thanks