Forum Discussion
Sum maxx
Hello, I try to have a measure to have a sum for the value for one column . I need in my graph the max value and not a variation value, it's possible ? Thanks in adv.
Vanessa250919
Max Postal Code for each city? or Max City among all cities? The later would be
NBR_PAR_Max =
MAXX ( ALLSELECTED ( 'Table'[City] ), CALCULATE ( SUM ( 'Table'[NBR_PAR] ) ) )
Max for all cities, in this case I have max for one city
NBR_PAR_Max =
MAXX ( VALUES ( 'Table'[Postal Code] ), CALCULATE ( SUM ( 'Table'[NBR_PAR] ) ) )I try this measure and I have the same result
Vanessa250919
Please provide some sample data along with the expected result.