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

     

FrederikB's avatar
FrederikB
Frequent Visitor
3 years ago

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's avatar
    tamerj1
    Community Champion
    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] ) )
)