Forum Discussion

Gheb_Gabriela's avatar
Gheb_Gabriela
Frequent Visitor
4 years ago

AVERAGE FORMULA

Hi all, I need help with something, if you have any idea:   I have used the below formula to make a measure for what I need in the report and it works for me, but is there any way to can add avera...
Need Help
Tips and Tricks
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

Gheb_Gabriela 

Try like , if they are columns

 

divide(sum(Table[Bonus_payout]), Sum(Table[Bonuspayout count]) )

 

if they are measure avg should already be  correct

 

 

divide([Bonus_payout],[Bonuspayout count])

 

or use like this using columns on row and column of matrix

 

averaged(Summarize(Table, Table[row column], Table[Column Column), calculate(divide([Bonus_payout],[Bonuspayout count]))

Gheb_Gabriela's avatar
Gheb_Gabriela
Frequent Visitor
4 years ago

amitchandak thanks a lot for your solutions but it's not working. With the first measure, if i am trying to apply it, doesn't find my measures ( bonus payout and bonus payout count) and the second one, give me the same results.

In excel my formula is this one:

In power Bi first i have sum the column, after that i've made the count for the same column and after that i've used the iferror in Power BI and the result is good, same with my analysis from Excel, but now, I only need the average for totals... 

 

I don't know why it's not working. I can't make the average for the same column twice. It is not what I need to get the correct results for my report.

 

Thank you in advance!

 

Have a great day!