topic Calculated Column not being executed in DAX Commands and Tips

Calculated Column not being executed

Pablinho — Tue, 19 Sep 2023 20:05:02 GMT

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!

Re: Calculated Column not being executed

lbendlin — Thu, 21 Sep 2023 01:16:58 GMT

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

Re: Calculated Column not being executed

Pablinho — Thu, 21 Sep 2023 13:04:00 GMT

Hello!

They are not, they are numeric values.

Re: Calculated Column not being executed

lbendlin — Thu, 21 Sep 2023 13:58:39 GMT

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