Skip to main content
cancel
Showing results for 
Search instead 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

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
Europe Fabric Conference

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 Carousel June 2024

Power BI Monthly Update - June 2024

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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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