Weighted average.

[BhanuPBI]

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.

[tamerj1 · Accepted solution]

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]

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.