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

Responsive Resident

## Maximum Value of of Measure

I have a measure called "Total Applications" which I have ploted on a line chart against "Year" from a calendar as follows:

How can I get the maximum total applications for the date range on the plot?

7 REPLIES 7
Community Support

You can refer to the following example:

``calculate(Maxx(all(table),[Total Applications]),DATESBETWEEN(CALENDAR[Date],yourstartdate,yourenddate))``

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Resolver III

@Chitemerere , you need to set and use a Date table for this solution.

The logic for the measure is something like this:

`Highest Total Applications = VAR minDate = MIN(dimDate[Date])VAR maxDate = MAX(dimDate[Date])VAR result =    CALCULATE(        MAX('Table'[Value]),        'Table'[Date] >= minDate && 'Table'[Date] <= maxDate    )RETURNresult`

Responsive Resident

Thank you very much for your response.  I am confused, which table and value are referred to above in 'Table' and 'Value'

Responsive Resident

Thank you very much.  I am confused, wich table 'Table' and value 'Value' are referred here?

Resolver III

It's a general solution, you have change the table and value to your own datamodel.

We can help but you need to share the details of your model/measures.

Responsive Resident

Managed to solve it with the following DAX:

Highest Total Applications = MAXX(SUMMARIZE(ALL(NewApplications),NewAppCalendar[Year]), [Total Applications]).  Is it possible to have a DAX measure which gives the "Year" for this "Highest Total Applications"??
Resolver III

For the date of highest total application (MaxDate) you can try this:

`MaxDate = VAR maxvalue = 'Table'[Highest Total Applications]VAR result =    CALCULATE(        VALUES(dimDate[Date]),        FILTER(            'Table',            'Table'[Value] = maxvalue        )    )RETURNresult`

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 - August 2024

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

#### Fabric Community Update - August 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors