CALCULATE first expression: must be a measure?

[webportal]

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?

[Sean]

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]

@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]

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/

[Vvelarde · Accepted solution]

@webportal

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

Like Sum, Count, Average, Values or another