Forum Discussion
AVG total in matrix
I am trying to generate a % spent column by dividing my actual cost and current budget.
the issue i am running in to is the totals.
I am switching from tableau and i am having a very difficult time with making PBI do simple averages like this.
the averages i am getting are not correct.
any help will be appreciated
Anonymous , if they are columns
Divide(Sum('Dashboard'[Actual Cost]),Sum('Dashboard'[Current Budget]) )
if the ate measure and you need Avg of Avg
AverageX(Values('Dashboard'[TOP Name]), Calculate(Divide('Dashboard'[Actual Cost],'Dashboard'[Current Budget]) ) )
1 Reply
- amitchandak
Super User
Anonymous , if they are columns
Divide(Sum('Dashboard'[Actual Cost]),Sum('Dashboard'[Current Budget]) )
if the ate measure and you need Avg of Avg
AverageX(Values('Dashboard'[TOP Name]), Calculate(Divide('Dashboard'[Actual Cost],'Dashboard'[Current Budget]) ) )