Forum Discussion
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...
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
If you can see the total.. It shows 1,68,075.. But it should have been close to 6000.. 😞
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