Forum Discussion
What and how to use an aggregate function?
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))
Community ChampionYou 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)Hi Anonymous,
are you searching for something like this?
I've divided your problem into two functions.
Let me know if it works and if it's what are you searching for.
#I'M Not An Expert#
@ B129 this solution solves half of my problem in my case I will use this measure in graphs and also in tables and often I will not add the column that I am on the chart ortable that I am applying as far as your example Column which brings the value "a".
I will do some testing but I still have to more acrescertar something far.