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 below.

 

How can I fix this?

 

 

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

     

3 Replies

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