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

jaideepnema's avatar
jaideepnema
Solution Sage
4 years ago

Hi Adity ,
can you please share some sample data for the same and also the expected output ?

  • Adity's avatar
    Adity
    Regular Visitor
    4 years ago

    This i what I am expecting.. It has the total sales thi year and total sales last year. It finds the MIN .. BUt while summing up .. It creates an issue. Need help to fix thisThis is the sample.. Have the Total sales and comparing with sales last year. Finding the Minimum of it too! but somewhere I miss the total of it.. Can u suggest something on why this happens?