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

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

      • dansuk6's avatar
        dansuk6
        Frequent Visitor
        4 years ago

        amitchandak 어떻게 공유할 수 있나요?