Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Efficency calculation

Hello, I have data, "total time it took to create the part"(time) and "working mins" (Whole Number). Is here a way to divide one into the other. This data would then be used to provide a percentag...
Need Help
  • v-cherch-msft's avatar
    v-cherch-msft
    7 years ago

    Hi Anonymous 

    Create a measure like below.Then drag the date column and the measure to a table visual.

    Measure =
DIVIDE (
    CALCULATE ( SUM ( Table1[Time_Second] ) ),
    CALCULATE ( MAX ( Table1[Working-Second] ) )
)

    Regards,

v-cherch-msft's avatar
v-cherch-msft
Microsoft Employee
7 years ago

Hi Anonymous 

Please check below measure:

Measure =
DIVIDE (
    CALCULATE (
        SUM ( Table1[Time_Second] ),
        FILTER ( Table1, Table1[Date] = DATE ( 2019, 4, 16 ) )
    ),
    CALCULATE (
        MAX ( Table1[Working-Second] ),
        FILTER ( Table1, Table1[Date] = DATE ( 2019, 4, 16 ) )
    )
)

 

Regards,

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Yes that looks to be exactly what i am am looking for.

Is there a way i can do the measure for all the days? 

 

Apologies if this is simple, would be a novice to Dax

 

v-cherch-msft 

  • v-cherch-msft's avatar
    v-cherch-msft
    Microsoft Employee
    7 years ago

    Hi Anonymous 

    Create a measure like below.Then drag the date column and the measure to a table visual.

    Measure =
DIVIDE (
    CALCULATE ( SUM ( Table1[Time_Second] ) ),
    CALCULATE ( MAX ( Table1[Working-Second] ) )
)

    Regards,