Forum Discussion

Anonymous

Not applicable

10 years ago

Filter on the measure.

I need to create a measure that makes a calculation using the SUMX function but also has a filter, for example SUMX (table; max (year column); column1 * column2) and will also need to create a measur...

Icon for Community Champion rank

Community Champion

10 years ago

The general formula for a measure like that is:

SUMX(FILTER(...),...)

Or you can use CALCULATE

CALCULATE(SUM(...),FILTER(...))

without sample data, not sure how much more I can help.

Anonymous
Not applicable
10 years ago
Greg_Deckler

I'm trying it

(SUMX (FILTER (DMEGF_Ano; max (DMEGF_Ano [Year])) facts, facts[Vl_PedidoCompra] * facts [Qtd_PedidoCompra]))

but it is giving error
- Sean
  Community Champion
  10 years ago
  Anonymous try this
  delete the facts and add => comma and ( => , (
  - Anonymous
    Not applicable
    10 years ago
    Sean Greg_Deckler
    
    I did as suggested however without success, maybe I'm trying to make wrong way, what I need is to get the value of a calculation over a year filtered and also the value of it in anetrior period to the filtrate, for example, I want to know the total sales of the year 2016 and in a different measure present value of 2015
- Greg_Deckler
  Community Champion
  10 years ago
  The error I see is the first "facts", get rid of that.
  
  Also, and this is purely a guess that your FILTER clause should be:
  
  FILTER (facts; max (DMEGF_Ano [Year]))
  - Anonymous
    Not applicable
    10 years ago
    but the SUMX function asks to be declared a table, any suggestions?