Forum Discussion

Kurumi0418's avatar
Kurumi0418
Icon for Helper I rankHelper I
8 years ago
Solved

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?

 

Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

    Kurumi0418

     

    Try this MEASURE

     

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

1 Reply

  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    Icon for Community Champion rankCommunity Champion
    8 years ago

    Kurumi0418

     

    Try this MEASURE

     

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