Forum Discussion
What and how to use an aggregate function?
Community ChampionYou most likely need to add SUM to the Measure you are trying to create...
But you need to explain a bit more - what are you trying to do???
In my need to calculate a measured value in which I will have to use the IF function, and aggregation would be applied to the fields from other tables, for example:
Measured = sum (AGGR (if (table.column = '9 - Deductions from Revenue', sum (table.Vl_Receita) + sum (table.Vl_Estorno), sum (table.Vl_Receita) - sum (table.Vl_Estorno)) [Desc Group Revenue], Nível01, year, month))
- Sean
You have to explain what you are trying to do and what the data looks like.
This is neither DAX nor M.
I need to create a measure for a given one cauculo value is made by adding two fields and the rest is made another calculation is independent of the value after the value is added for three other fields.
trying to give an example:
sum (Aggregation (If (table.column = 'a' then sum (table.columnA) + sum (table.columnB) else sum (table.columnA) - sum (table.columnB)), ColumnC, ColumnD, ColumnE)