Nulls in a results column when I wouldn't expect there would be any

Jun 1, 2016 at 11:09 PM
Edited Jun 1, 2016 at 11:11 PM
I have a date table ( 'calendar') joined on each of the tables in the statement below.
My question is, in the Results, why would I see nulls in reportDate if the modelPosition table has a reportDate foreign key to 'calendar'[reportdate]?

Thanks,
Brad
EVALUATE
ADDCOLUMNS(
        Addcolumns(
            SUMMARIZE (   --table
                'modelPositions'
                , 'calendar'[reportDate] 
                , 'Models'[modID]                           
                        )
            , "in" , CALCULATE(sum(modelFlows[inflows]))
            , "out" , CALCULATE(sum(modelFlows[outflows]))          
            , "beg", CALCULATE(sum(modelPositions[beginningBaseValue]) )
            , "end", CALCULATE(sum(modelPositions[BaseValue]) ) 
                )
        , "modTRdaily1", (([end]-[beg]-([in]+[out]))/([beg]+[in]))  
        )
Jun 1, 2016 at 11:17 PM
Umm... because I didn't refresh the entire model after I added the modelPositions table. Please ignore.