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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
JustSayJoe
Advocate II
Advocate II

Highest Daily Value of Measure for Each Category

There seems to be a lot of tutorials and responses to finding maximum values for dates, but none that I can find to fit my specific need.


Table = TestTable
Including columns:
     Team
     Date
     Payment
(there are more, but for all intents and purposes, these will suffice)

I also have a Measure that does a calculation returning a currency value. Let's call it, [Amount Measure].

I'm trying to return the single highest daily amount of that [Amount Measure] for each Team. Is there a DAX formula that can accomplish this?

2 ACCEPTED SOLUTIONS

I switched the VALUES portion to ALLSELECTED instead, and that seemed to fix things. Thanks for the assist!

View solution in original post

@JustSayJoe 

Sorry my mistake. It should be MAXX not MAX

MAXX ( 

VALUES ( testable[Date] ),

[Amount Measure]
)

View solution in original post

5 REPLIES 5
v-yetao1-msft
Community Support
Community Support

Hi @JustSayJoe 

I am so glad to hear that you have found the workaround . Please consider Accept it as the solution to help the other members find it more quickly. 

 

Best Regards,
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

tamerj1
Super User
Super User

Hi @JustSayJoe 

if you are slicing by team, simply try

MAX ( 

VALUES ( testable[Date] ),

[Amount Measure]
)

I received the following error when trying this.

"Calculation error in measure. A table of multiple values was supplied where a single value was expected."

I switched the VALUES portion to ALLSELECTED instead, and that seemed to fix things. Thanks for the assist!

@JustSayJoe 

Sorry my mistake. It should be MAXX not MAX

MAXX ( 

VALUES ( testable[Date] ),

[Amount Measure]
)

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors