Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
Shure846
Helper III
Helper III

MAX measure not correct?

Hi - I've got a table with USDA prices in it, and I'm using MIN, MAX and STDEV to give me an idea of how a commodity is tracking. The table has 4 different commodities in it, and MAX works for 3 of them, but not the 4th and I cannot figure out why. It's the same table being analyzed. 

 

The measure is : 

Maximum beef & pork = MAX('Combined beef & pork trim'[Weighted average])
 
Any suggestions? 
 
1 ACCEPTED SOLUTION
Shure846
Helper III
Helper III

I found out the issue - there were duplicate dates in the table. Apparently that confuses the DAX measure. 

 

 

View solution in original post

2 REPLIES 2
Shure846
Helper III
Helper III

I found out the issue - there were duplicate dates in the table. Apparently that confuses the DAX measure. 

 

 

sergej_og
Super User
Super User

The provided information base is quite small to reconstruct or undesteand the usecase
Can you provide sample data and expected result. At least screenshots would be a good start.

Regards

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.