Forum Discussion
Solved
Creating a new table using summerize
Hello, I have a realy weird calculation that doesnt seem to work. I am creating a new table with 3 columns from an existing table. The new table has 3 columns Revenue Gap - Whole number ...
Hi lcasey ,
including the amount-columns in the columns to aggregate on doesn't seem to make much sense in my eyes. What does the expression return if you omit them like so:
Revenue Gap = SUMMARIZECOLUMNS( Revenue[Campaign Name _x002dId], "Gap",SUM(Revenue[Revenue Gap]), "Revenue",sum(Revenue[Regularization]), "Average" ,DIVIDE(sum(Revenue[Regularization]),sum(Revenue[Revenue Gap])) )
Hi lcasey ,
including the amount-columns in the columns to aggregate on doesn't seem to make much sense in my eyes. What does the expression return if you omit them like so:
Revenue Gap =
SUMMARIZECOLUMNS(
Revenue[Campaign Name _x002dId],
"Gap",SUM(Revenue[Revenue Gap]),
"Revenue",sum(Revenue[Regularization]),
"Average" ,DIVIDE(sum(Revenue[Regularization]),sum(Revenue[Revenue Gap]))
)
That Worked!
It does add up the Total a little different as I think the overall average should be 115
Take 3749629 / 32619 = 114.95