Table total not correct

[FrederikB]

I have this table (I am sorry about the weird danish letters in the column names).

I have set it to automatically show the total, and it works in all the columns but the one showed in the image below.

How can I fix this?

[FrederikB]

The columns are from these tables:

• Åbn: All bookings
• Afholdelsesdato: All bookings
• Omsætning (meaning revenue): Invoices

Each booking has two invoices, and I have applied a filter to the table, which only shows data from one of the invoices. 

I have set the revenue column to Max, the reason being otherwise it will show a wrong value on some of the rows... But know that I think about it, I can see that the total row then shows the maximum value, which must be the intented behaviour. 

Which means that I will have to solve my overall problem in a different way that what I have done until now. Thank you!

[tamerj1 · Accepted solution]

@FrederikB 
Apologies for the late response. Please try new measure:

Sum of Max Omsætning =
SUMX (
    SUMMARIZE ( Invoices, 'All bookings'[Åbn], 'All bookings'[Afholdelsesdato] ),
    CALCULATE ( MAX ( Invoices[Omsætning] ) )
)

[tamerj1]

Hi @FrederikB