Forum Discussion

Vanessa250919's avatar
Vanessa250919
Icon for Helper V rankHelper V
3 years ago

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's avatar
Vanessa250919
Icon for Helper V rankHelper V
3 years ago

POSTAL_CODE               NBR_PAR
1000                              2
2000                              4

3000                              2

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

  • tamerj1's avatar
    tamerj1
    Icon for Community Champion rankCommunity Champion
    3 years ago

    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's avatar
      Vanessa250919
      Icon for Helper V rankHelper V
      3 years ago

      is an column .
      city in graph .

      • tamerj1's avatar
        tamerj1
        Icon for Community Champion rankCommunity Champion
        3 years ago

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