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

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

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

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

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

     

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

    Vanessa250919 

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

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

    I try this measure and I have the same result

     

     

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

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