Forum Discussion

BhanuPBI's avatar
BhanuPBI
Frequent Visitor
3 years ago
Solved

Weighted average.

Hi Team,   Can any one help me to create report for weighted average time taken for extracting the invoice by client wise. For your reference i have shared screenshot below of my table. please...
Need Help DAX
  • tamerj1's avatar
    tamerj1
    3 years ago

    Hi BhanuPBI 
    I hope this is what you are looking for. Please refer to attached sample file .

    Time = SUM ( 'Table'[Time taken] )
    Average Time = 
DIVIDE (
    [Time],
    CALCULATE (
        [Time],
        ALL ( 'Table' ),
        VALUES ( 'Table'[Client] )
    )
)

     

tamerj1's avatar
tamerj1
Community Champion
3 years ago

Hi BhanuPBI 
I hope this is what you are looking for. Please refer to attached sample file .

Time = SUM ( 'Table'[Time taken] )
Average Time = 
DIVIDE (
    [Time],
    CALCULATE (
        [Time],
        ALL ( 'Table' ),
        VALUES ( 'Table'[Client] )
    )
)