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

amitchandak's avatar
amitchandak
Super User
4 years ago

Adity , For total you need force a row context

 

example

 

Sumx(Values('Date'[Month Year]), calculate( MIN( [Total Sales], [Sales LY] )))

  • Adity's avatar
    Adity
    Regular Visitor
    4 years ago

    amitchandak  For some reason I dont find any change in the solution. By giving your query i wasnt able to see the MIN values in my column.