Forum Discussion

Pablinho's avatar
Pablinho
Icon for Helper I rankHelper 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....
BUG
calculated column
DAX
error
Help
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

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

Pablinho's avatar
Pablinho
Icon for Helper I rankHelper I
2 years ago

Hello!

They are not, they are numeric values.

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    2 years ago

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