Unable to Sum a Calculated value in a different table

[Anonymous]

Hello,

I'm new to Power Bi so apologies if this is obvious but I cannot figure out why my DAX isn't working! Any help is appreciated.

I have Table "FTE" which has columns brought through from a JSON query from a database containing several thousand rows of data. I have extended this table with an additional column called "FTE_Calc_August" which uses DAX code to generate it's output values. This works correctly.

I also have Table B, related to Table FTE with a 1:many relationship. This contains 10 rows of data, 1 row per business site location. This needs to show summarised data per site.

Within Table A, I have created a new column called "Variance_Aug" in which I want sum all the "FTE_Calc_August" values within Table FTE filtered by SiteID. I have tried using the following:

Variance_Aug = CALCULATE (SUM ( FTE[FTE_Calc_August] ), 'FTE'[data.siteID] = 17) but each time i hit enter to run the query, the DAX code resets itself to the last successful code command.

I have tested using a column in the FTE table called "tuesday" which is a static value pulled in via the JSON file (therefore no DAX involved) and it works, therefore I know the syntax is correct.  

Variance_Aug = CALCULATE (SUM ( FTE[data.tuesday] ), 'FTE'[data.siteID] = 17 )

It seems that my use of a DAX coded column is the issue. Does anyone know why this is the case and, more importantly, how I get around the problem?!

Many thanks in advance.

[Greg_Deckler]

@Anonymous Any chance you can provide sample data or the PBIX?