How to use Average first and Sum rule???

[Kurumi0418]

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?

[Zubair_Muhammad · Accepted solution]

@Kurumi0418

Try this MEASURE

Measure =
IF (
    HASONEFILTER ( Table1[Oper] ),
    AVERAGE ( Table1[StepProcessTime] ),
    SUMX (
        VALUES ( Table1[Oper] ),
        CALCULATE ( AVERAGE ( Table1[StepProcessTime] ) )
    )
)