Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
webportal
Impactful Individual
Impactful Individual

Using a Boolean expression with CALCULATE

 

Can someone explain me why this expression of a calculated measure works:

 

Measure = CALCULATE(SUM(Facts[Turnover]);FILTER('Facts';'Facts'[UnitPrice]>=50))

 Whereas this one doesn't:

 

Measure = CALCULATE(SUM(Facts[Turnover]);'Facts'[UnitPrice]>=50)

I know CALCULATE can use a Boolean expression or a table expression that defines a filter, but isn't the second expression using a Bolean condition:

'Facts'[UnitPrice]>=50

 

1 ACCEPTED SOLUTION

This is correct. No measure or CALCULATE expression, unless you write a full FILTER expression around it.

View solution in original post

10 REPLIES 10
KHorseman
Community Champion
Community Champion

In what sense does the second formula "not work"? It appears to work fine in my test.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




webportal
Impactful Individual
Impactful Individual

Hello,

 

I get the error:

Capturar.JPG

 

 

 

This means something like: "A CALCULATE function was used in a TRUE/FALSE expression as a table filter. This is not allowed".

And this message gets me even more confused.

 

However, the following function works perfectly:

Capturar2.JPG


Are you adding that formula as a measure or a column?





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




webportal
Impactful Individual
Impactful Individual

As a measure.

If 'Facts'[UnitPrice] is a calculated column, this expression

Measure = CALCULATE(SUM(Facts[Turnover])
;'Facts'[UnitPrice]>=50
)

is just a shortcut for:

Measure = CALCULATE(SUM(Facts[Turnover])
;FILTER( ALL('Facts'[UnitPrice])
;'Facts'[UnitPrice]>=50
)
)

 If 'Facts'[UnitPrice] is a measure, however, you will get an error message about CALCULATE not being allowed in a filter expression expression (of a CALCULATE expression).

 

Is it what is happening here?

Yes, 'Facts'[UnitPrice] is a measure.

Then you have your answer. Man Happy

Ok, so the answer is I can't use a calculated measure in CALCULATE but I can use in FILTER function, correct?

For a calculated column, you have the row context active, so row by row you can use the boolen expression. For the measure, there would be no row context active as it would be expected by the boolean expression. 

 

This is correct. No measure or CALCULATE expression, unless you write a full FILTER expression around it.

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.