Forum Discussion

Bhanu_chPBI's avatar
Bhanu_chPBI
Icon for Helper I rankHelper I
3 years ago
Solved

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

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.

 

 



 

3 Replies

  • BeaBF's avatar
    BeaBF
    Icon for Super User rankSuper User
    3 years ago

    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's avatar
      Bhanu_chPBI
      Icon for Helper I rankHelper I
      3 years ago

      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's avatar
        BeaBF
        Icon for Super User rankSuper User
        3 years ago

        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.