Forum Discussion
MIN Function giving wrong total
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
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
PhilipTreacy .. Can you please check the tread below.. I added the picture of What i am expecting excatly.
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
