cancel
Showing results for
Did you mean:
Highlighted
Helper I

## Average of grouped max

Hello guys,

I have troubles trying to find way to solve this calculation. I need the average of max delivered days values grouped by num order

I try with this measure

```delivered days grouped = SUMX(VALUES(Time[NumOrder])
,MAX(Time[Delivereddays])
)```

and then

`avg days = DIVIDE([delivered days grouped],[Orders],0)`

But what i obtain is 11 and i dont know why, please can you help me?

2 ACCEPTED SOLUTIONS

Accepted Solutions
Anonymous
Not applicable

## Re: Average of grouped max

Hi @jpereztang

You can try this:

```=
VAR x =
SUMMARIZE ( 'Time'; 'Time'[Num Order]; "dd"; MAX ( 'Time'[Delivered Days] ) )
RETURN
AVERAGEX ( x; [dd] )```

Super User III

## Re: Average of grouped max

If you just wrap a CALCULATE around the MAX() in your first measure it should work. The current problem is that with no calculate there is no context transition and MAX() always yields 11, the max for the full [Delivered days] column.

4 REPLIES 4
Anonymous
Not applicable

## Re: Average of grouped max

Hi @jpereztang

You can try this:

```=
VAR x =
SUMMARIZE ( 'Time'; 'Time'[Num Order]; "dd"; MAX ( 'Time'[Delivered Days] ) )
RETURN
AVERAGEX ( x; [dd] )```

Helper I

## Re: Average of grouped max

at first sight it fits perfectly. Thank you.

Super User III

## Re: Average of grouped max

If you just wrap a CALCULATE around the MAX() in your first measure it should work. The current problem is that with no calculate there is no context transition and MAX() always yields 11, the max for the full [Delivered days] column.

Helper I

## Re: Average of grouped max

@AlB this also works, i couldn't figure out why this measure doesn't work if in the past work for similar scenario and as you say is because i was omitted calculate.    Thank you!

Announcements

#### Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

#### MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

#### ‘Better Together’ Integration Forum Launch

We've launched a how-to forum where you can learn about how Power BI integrates with other Power Platform products.

Top Solution Authors
Top Kudoed Authors