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 create any sample pbix file to show the weighted average for each invoice time taken by client wise.

 

 

 
 
 
 
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] )
    )
)

     

2 Replies

  • 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] )
    )
)

     

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Super User
    3 years ago

    Hi,

    I am not sure how you weigh each invoice, but please check the below picture and the attached pbix file.

    The below is one of ways to calculate weighted avg.

    I hope the below can provide some ideas on how to create a solution for your data model.