Forum Discussion
What and how to use an aggregate function?
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.And Anonymous have not yet found a role in Power BI that do the same thing AGGR or Agregate function, only noting that the purpose of this function is:
returns a calculated expression values indicated on the size and dimensions.
Anonymous I simply gave you my solution, I'm not an expert and I still have a lot of things to learn.
So it's better that you ask to someone else.