cancel
Showing results for
Did you mean:
Highlighted
Member

## 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?

1 ACCEPTED SOLUTION

Accepted Solutions
Super Contributor

## Re: CALCULATE first expression: must be a measure?

@webportal

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

Like Sum, Count, Average, Values or another

Lima - Peru

Proud to be a Datanaut!

4 REPLIES 4
Super Contributor

## Re: CALCULATE first expression: must be a measure?

@webportal

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

Like Sum, Count, Average, Values or another

Lima - Peru

Proud to be a Datanaut!

Super Contributor

## Re: CALCULATE first expression: must be a measure?

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]

Member

## Re: CALCULATE first expression: must be a measure?

@Sean, the expression is:

I think I got the idea: since Faturação * is already agregating it works, whereas Faturação is just a column.

Super Contributor

## Re: CALCULATE first expression: must be a measure?

Yes and you can add the FILTER in your Measure like this...

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

https://www.powerpivotpro.com/2014/10/sum-sumx-or-calculatechoices-choices/

Announcements

#### Community News & Announcements

Get your latest community news and announcements.

#### Power Platform Summit North America

Register by September 5 to save \$200

#### Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

#### Watch Sessions On Demand!

Continue your learning in our online communities.

Top Kudoed Authors
Users Online
Currently online: 199 members 2,596 guests
Recent signins: