topic Re: Need dax calculation Min,Max,Avg,Weighted Avg. in DAX Commands and Tips

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

Bhanu_chPBI — Tue, 13 Dec 2022 12:43:48 GMT

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.

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

BeaBF — Tue, 13 Dec 2022 12:56:34 GMT

Bhanu_chPBI Try this measure:

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

BBF

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

Bhanu_chPBI — Wed, 14 Dec 2022 05:37:41 GMT

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.

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

BeaBF — Wed, 14 Dec 2022 08:12:29 GMT

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.