Calculated Column not being executed

[Pablinho]

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!

[lbendlin]

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

[Pablinho]

Hello!

They are not, they are numeric values.

[lbendlin]

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