Forum Discussion

Icon for Impactful Individual rank

Impactful Individual

9 years ago

Solved

CALCULATE first expression: must be a measure?

Why does this measure works:

Medida = CALCULATE('Factos'[Faturação *];FILTER('Factos';'Factos'[PreçoUnitário]>=50))

Whereas this one doesn't:

Medida = CALCULATE('Factos'[Faturação];FILTER('Factos';'Factos'[PreçoUnitário]>=50))

The difference is that "Faturação *" is a measure while "Faturação" is a column.

By reading the DAX reference here, I can see the following remark:

The expression used as the first parameter is essentially the same as a measure.

So, what's the conclusion? That I must use a calculation as the 1st argument of the function?

Vvelarde
9 years ago
webportal

The second fail because you need to say what calculation or function need to do.

Like Sum, Count, Average, Values or another

4 Replies

Vvelarde
Community Champion
9 years ago
webportal

The second fail because you need to say what calculation or function need to do.

Like Sum, Count, Average, Values or another
Sean
Community Champion
9 years ago
When you are referencing a COLUMN you need some kind of aggregation like SUM, etc..
What is the formula in your Measure?

Also when you reference a Column use the TableName[Column Name]
when you reference a Measure just the [Measure Name]
https://www.powerpivotpro.com/2014/10/5-common-mistakes-made-by-self-taught-dax-students/
- webportal
  Impactful Individual
  9 years ago
  Sean, the expression is:
  Faturação * = SUMX('Factos';'Factos'[PreçoUnitário]*'Factos'[Unidades])
  
  I think I got the idea: since Faturação * is already agregating it works, whereas Faturação is just a column.
  - Sean
    Community Champion
    9 years ago
    Yes and you can add the FILTER in your Measure like this...
    
    Faturação * = SUMX ( FILTER ( 'Factos'; 'Factos'[PreçoUnitário] >= 50 ); 'Factos'[PreçoUnitário] * 'Factos'[Unidades] )
    
    https://www.powerpivotpro.com/2014/10/sum-sumx-or-calculatechoices-choices/