This project has moved and is read-only. For the latest updates, please go here.

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

Jun 2, 2016 at 12:09 AM
Edited Jun 2, 2016 at 12:11 AM
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]?

            SUMMARIZE (   --table
                , '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 2, 2016 at 12:17 AM
Umm... because I didn't refresh the entire model after I added the modelPositions table. Please ignore.