topic Re: Weighted average. in DAX Commands and Tips

Weighted average.

BhanuPBI — Fri, 30 Dec 2022 10:13:56 GMT

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.

Re: Weighted average.

Jihwan_Kim — Fri, 30 Dec 2022 10:54:46 GMT

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.

Re: Weighted average.

tamerj1 — Fri, 30 Dec 2022 13:36:55 GMT

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