Creative Ways to Express Sum (table/matrix visual

hello stribor45 

i might be wrong but if you are looking for conditional formating for auto total value in table visual, i doubt there is an option to do conditional formating.

i am not sure how your data looks like but if i have to create this, i would create Total value as row value.

1. Create calculate columns for 'Tickets' and 'Amounts'

Tickets =
IF(
    'Table'[Ticket Type]="Total",
    SUM('Table'[Number of Tickets]),
    'Table'[Number of Tickets]
)

Amounts = 
IF(
    'Table'[Ticket Type]="Total",
    SUM('Table'[Amount]),
    'Table'[Amount]
)

2. create a measure for Total color and assign the color

Total Color =
IF(
    SELECTEDVALUE('Table'[Ticket Type])="Total",
    "Red"
)

 

3. disable Total so it will not show Total value

4. if needed, put rank in table visual as sort value so Total will always be in the bottom.

 

i am awared this is not perfect but this is one of many tricks.

Hope this will help.
Thank you.