Forum Discussion
Vanessa250919
3 years agoHelper V
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
3 years agoHelper V
POSTAL_CODE NBR_PAR
1000 2
2000 4
3000 2
In my graph in need the sum 8 and not the maxx 4 .
tamerj1
3 years agoCommunity Champion
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?
- Vanessa2509193 years agoHelper V
is an column .
city in graph .- tamerj13 years agoCommunity Champion
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 measureNBR_PAR_Measure = SUM ( 'Table'[NBR_PAR] )- Vanessa2509193 years agoHelper V
Ok, it's work, but I need to used the max of this measure in my graph to have a steady bar