Forum Discussion

Pablinho's avatar
Pablinho
Helper I
2 years ago

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

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

      • lbendlin's avatar
        lbendlin
        Super User

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