cancel
Showing results for
Search instead for
Did you mean:
Regular Visitor

## How to use Average first and Sum rule???

Hello.

I have one question :

How to use measure to : Average and sum???

I Need average STEP PROCESS TIME first, and I Need sum this measure values not average. so How can I do?

1 ACCEPTED SOLUTION

Accepted Solutions
Super User III

## Re: How to use Average first and Sum rule???

@Kurumi0418

Try this MEASURE

```Measure =
IF (
HASONEFILTER ( Table1[Oper] ),
AVERAGE ( Table1[StepProcessTime] ),
SUMX (
VALUES ( Table1[Oper] ),
CALCULATE ( AVERAGE ( Table1[StepProcessTime] ) )
)
)```
Try my new Power BI game Cross the River
1 REPLY 1
Super User III

## Re: How to use Average first and Sum rule???

@Kurumi0418

Try this MEASURE

```Measure =
IF (
HASONEFILTER ( Table1[Oper] ),
AVERAGE ( Table1[StepProcessTime] ),
SUMX (
VALUES ( Table1[Oper] ),
CALCULATE ( AVERAGE ( Table1[StepProcessTime] ) )
)
)```
Try my new Power BI game Cross the River

## Helpful resources

Announcements

#### Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

#### Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

#### Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

#### Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!

#### Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors
Top Kudoed Authors