Forum Discussion
Using aggregated value in a calculation.
Hello all,
I am relatively new to Power BI.
In my current project, I have a column of monthly usage. I know that I can pick different aggrated values such as Sum, or Average and it will show at the bottom of the column. I was wondering if I can use that number in a equation for a calculated column.
Thank you!
Hi weisheng,
As you see, the Aggregated Values show at the bottom of the table. But it is not possible to use them directly into some other expression or calculated column
Instead you can use that by manually specifying in a DAX statement, for ex. in your case, suppose you want to find the difference between the Total monthly usage and Average monthly usage for each month, you can create and use a measure like the one below
Difference = AVERAGE(Table1[Usage]) - SUM(Table1[Usage])
Here AVERAGE(Table1[Usage]) holds the same value as your aggregated column total. i.e. 773.25