Forum Discussion

dansuk6's avatar
dansuk6
Frequent Visitor
4 years ago

help me....

You want to calculate the arithmetic mean of the data by the amount going in and the amount overall, as shown in the figure above. I don't know what to do Help me

9 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    dansuk6 ,

    you need to try measure like

    calculate(average(Table[Value]))

     

     

    overall

    calculate(average(Table[Value]), allselected() )

    • dansuk6's avatar
      dansuk6
      Frequent Visitor
      4 years ago

      I'm sorry, but could you explain it more easily?

      • amitchandak's avatar
        amitchandak
        Super User
        4 years ago

        dansuk6 .
        Can you share sample data and sample output in table format? I will try share a pbix

  • tamerj1's avatar
    tamerj1
    Community Champion
    4 years ago

    HI dansuk6 
    Would you please explain further this type of calculation. What are the excel formulas invloved?

    • dansuk6's avatar
      dansuk6
      Frequent Visitor
      4 years ago

       

       

      =IFERROR(IFS(AND($AA6="",$AB6=""),AR3,AR3>0,(AR3*$AZ3+BC2*$BB2)/$BB3,AR3<=0,BC2),"")

       

       

      Using these formulas, calculate the arithmetic mean when in and get the previous arithmetic mean data when out.