Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
100 | |
81 | |
70 | |
62 |
User | Count |
---|---|
148 | |
116 | |
104 | |
90 | |
65 |