Forum Discussion

FrederikB's avatar
FrederikB
Frequent Visitor
3 years ago
Solved

Table total not correct

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 belo...
Need Help
Show and Tell
  • tamerj1's avatar
    tamerj1
    3 years ago

    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] ) )
)