Total and subtotal in hierarchy with max values

[Mauri96]

Hello everyone,
I have the following problem detailed in the picture. Subtotals are adjusted up to the month (December and November) but the Q4 (Trim 4)  subtotal must report the higher values of the December and November values (8,223,200.16 and not 14,864,9.04). can someone help me?

Thanks

[MAwwad]

To achieve this, you will need to create a new measure that calculates the maximum value for the Q4 subtotal. You can use the MAX() function in combination with the SUM() function to calculate this.

Here's an example of how you can create such a measure:

Copy code

Q4 Max = MAX( SUM( 'Table'[Value] ), FILTER( ALL( 'Table'[Date] ), 'Table'[Date].[Quarter] = MAX( 'Table'[Date].[Quarter] ) ) )

This measure will sum up the values for the current context and then return the maximum value for the current quarter.

Then you can use this measure in the table visual, instead of the original measure, to show the correct subtotal for Q4.

Please note that I assumed you have a date table and it is related to your table and the date column is named "Date" and the column you want to sum is named "value" and the quarter column is named "Quarter" you should adjust the formula accordingly.

[Mauri96]

Thanks for the answer, but it doesn't work, still have the same results. really I don't know..