Forum Discussion

Adity's avatar
Adity
Regular Visitor
4 years ago
Solved

MIN Function giving wrong total

I have 2 measures say Total_Sales & Sales_LastYear. I needs to find the MIN of these two column and sum the MIN value. When I do so, It shows the sum of Sales_LastYear. Dax used: Minimum...
Need Help
  • v-easonf-msft's avatar
    v-easonf-msft
    4 years ago

    Hi, Adity 

    Maybe it need a little modified ,try to add another formula as below:

    Measure = SUMX('Table',[Minimum (Incorrect Total)])

    or

    Measure = SUMX('Date'[Month Year],[Minimum (Incorrect Total)])

     

    If it doesn't work , please share your sample file for further research.

     

    Best Regards,
    Community Support Team _ Eason

PhilipTreacy's avatar
PhilipTreacy
Super User
4 years ago

Hi Adity 

You need to show us your data and what you are doing otherwise we're working in the dark and guessing.

You said that you've got 2 measures and that you need to find the MIN of these 2 columns.  Measures and Columns are different things.  You can't get the MIN of a measure because a measure only produces a single value.

Again, without seeing you data and your calculations, it's not clear what you are trying to do.

Regards

Phil

Adity's avatar
Adity
Regular Visitor
4 years ago

If you can see the total.. It shows 1,68,075.. But it should have been close to 6000.. 😞

  • v-easonf-msft's avatar
    v-easonf-msft
    Community Support
    4 years ago

    Hi, Adity 

    Maybe it need a little modified ,try to add another formula as below:

    Measure = SUMX('Table',[Minimum (Incorrect Total)])

    or

    Measure = SUMX('Date'[Month Year],[Minimum (Incorrect Total)])

     

    If it doesn't work , please share your sample file for further research.

     

    Best Regards,
    Community Support Team _ Eason