What and how to use an aggregate function?

Question

I need to create a measure and it have to use an aggregation

sean · Answer

You have to explain what you are trying to do and what the data looks like.&nbsp;This is neither DAX nor M.

anonymous · Answer

Hi&nbsp;Anonymous,&nbsp;&nbsp; &nbsp;are you searching for something like this?&nbsp;&nbsp;I've divided your problem into two functions.Let me know if it works and if it's what are you searching for.&nbsp;#I'M Not An Expert#

sean · Answer

You most likely need to add SUM to the Measure you are trying to create...&nbsp;But you need to explain a bit more - what&nbsp;are you trying to do???

anonymous · Answer

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))

anonymous · Answer

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)

Forum Discussion

What and how to use an aggregate function?

8 Replies

Related content

Boolean Aggregate Functions?

performing filter and aggregate function on dataset before applying TOPN

Data Aggregation issue

Max Function Aggregate

Choose aggregation function dynamically