Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Solved! Go to Solution.
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
Proud to be a Super User!
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
@PhilipTreacy .. Can you please check the tread below.. I added the picture of What i am expecting excatly.
Hi @Adity ,
can you please share some sample data for the same and also the expected output ?
This 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?
@Adity , For total you need force a row context
example
Sumx(Values('Date'[Month Year]), calculate( MIN( [Total Sales], [Sales LY] )))
@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.
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
88 | |
86 | |
82 | |
66 | |
49 |
User | Count |
---|---|
138 | |
110 | |
104 | |
66 | |
64 |