Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to 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] ) )
)
The columns are from these tables:
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!
@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] ) )
)
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
108 | |
105 | |
87 | |
74 | |
66 |
User | Count |
---|---|
124 | |
113 | |
96 | |
80 | |
72 |