cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

## 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!

Super User

Sorry my mistake. It should be MAXX not MAX

MAXX (

VALUES ( testable[Date] ),

[Amount Measure]
)

5 REPLIES 5
Community Support

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.

Super User

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!

Super User

Sorry my mistake. It should be MAXX not MAX

MAXX (

VALUES ( testable[Date] ),

[Amount Measure]
)

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - June 2024

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

#### New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors
Top Kudoed Authors