Forum Discussion

StevenT's avatar
StevenT
Icon for Helper V rankHelper V
2 years ago

minimum value working, max not working

Hi, I'm using a min and max to use in my KPI. The minimum works fine, but for some reason the maximum isn't giving me the maximum value. The highest value in the table is  1231 and it's incorrect ...
Need Help
PhilipTreacy's avatar
PhilipTreacy
Icon for Super User rankSuper User
2 years ago

StevenT 

 

Isn't the top chart a gauge?  If so just drag the Sales field into the Min and max wells and choose Min and Max as the aggregation?

 

 

If you have to write measures you can use

 

Min Sales = MIN(ALL('DataTable'[Sales]))
Min Sales = MAX(ALL('DataTable'[Sales]))

 

 

Regards

 

Phil

 

 

StevenT's avatar
StevenT
Icon for Helper V rankHelper V
2 years ago

That won't work in this case.  I have to basically calculate multiple sales and aggregate them together to discover the largest and smallest $.

  • PhilipTreacy's avatar
    PhilipTreacy
    Icon for Super User rankSuper User
    2 years ago

    StevenT 

     

    Please supply some sample data so that we know what you are working with and understand how you are getting the MAX and MIN values shown in your visual.

     

    Phil