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

To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.

Reply
Pablinho
Helper I
Helper I

Calculated Column not being executed

Hello!

 

I have a table called Progression1 with a calculated column generated with the following code:

Rate= CALCULATE(sum(Masterfile1[Awarded]),Masterfile1[STATUS]="GRD",Progression1[Term])/42.34)
 
It works perfectly, and it creates a column with the values that I need. However, when I try to replicate in my second table called Progression2, like this:
Rate= CALCULATE(sum(Masterfile2[Awarded]),Masterfile2[STATUS]="GRD",Progression2[Term])/42.34)

Nothing happens. I don't get the usual loading screen and seems like the code is not being executed at all. If I click anything afterwards the calculated column goes back to the default Column =

Anyone has any idea why does this happens? Is it something on my end?
 
Thank you!
 



3 REPLIES 3
lbendlin
Super User
Super User

Are Progression1[Term] and Progression2[Term] boolean values (evaluating to true or false)?

Hello!

They are not, they are numeric values.

then you need to refactor your query.  Filters are expected to either be tables or booleans.

Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

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