Need dax calculation Min,Max,Avg,Weighted Avg.

[Bhanu_chPBI]

Hi Team,

I'm seeking help with calculating an weighted average in my Power BI model.  For reference I have attached screenshot below. i need to show weighted average Timetake for submiting the Invoices by client wise. 

Thanks in advance for any guidance you can offer.

[BeaBF]

@Bhanu_chPBI Try this measure:

Measure = DIVIDE(CALCULATE(SUM('Table'[TimeTaken]), ALLEXCEPT('Table','Table'[Client])), CALCULATE(COUNT('Table'[TimeTaken]), ALLEXCEPT('Table','Table'[Client])))

BBF

[Bhanu_chPBI]

Hello @BeaBF ,

If you don't mind can you pls take sample data according to my screenshot and do some sample report and can send it to me please. 

[BeaBF · Accepted solution]

@Bhanu_chPBI if I have misinterpreted the result you want to obtain, I ask you to show me an example of output, I will help you build the measurement.