Sum maxx

[Vanessa250919]

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.

[tamerj1]

HI @Vanessa250919 
Please provide more information

[Vanessa250919]

POSTAL_CODE               NBR_PAR
1000                              2
2000                              4

3000                              2

In my graph in need the sum 8 and not the maxx 4 .

[tamerj1]

@Vanessa250919 
Is [NBR_PAR] a column in the sorce table or a measure? 

What are you slicing by in the graph? Aea, city, date, month?

[Vanessa250919]

is an column .
city in graph .

[tamerj1]

@Vanessa250919 
It should work. Double check the data type of the 'Table'[NBR_PAR] column. It has to be a number not a text. 
You may also create a measure

NBR_PAR_Measure = SUM ( 'Table'[NBR_PAR] )

[Vanessa250919]

Ok, it's work, but I need to used the max of this measure in my graph to have a steady bar

[tamerj1]

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

[Vanessa250919]

Max for all cities, in this case I have max for one city

[tamerj1]

@Vanessa250919 

NBR_PAR_Max =
MAXX ( VALUES ( 'Table'[Postal Code] ), CALCULATE ( SUM ( 'Table'[NBR_PAR] ) ) )

[Vanessa250919]

I try this measure and I have the same result

[tamerj1]

@Vanessa250919 
Please provide some sample data along with the expected result.