Table variable cannot be used in current context because a base table is expected by inflow calc

Hi MiKeZZa ,

Measure return a single value, meaning that you cannot make a measure that returns a table, this is the case that you are getting you are creating one table that returns the values.

In your case what you need to do is to count the number of rows for each table and return the result.

The result of your current table is:

The result of your previous table is:

If you llok at the values you have

If you redo your measure to the code below you get the correct result:

Inflow Inside 3 = 

VAR OfficePrevious = CALCULATETABLE(SUMMARIZE(DataFte,DataFte[Office Code],DataFte[EmpId])
                    --,PREVIOUSMONTH('Date'[Date]), ALL('Date')
                    ,'Date'[Month Number] = 4
                    ,DataFte[Internal] = "Y"
                    ,ALLEXCEPT(DataFte, DataFte[EmpId], DataFte[Office Code]))
                    
VAR OfficeCurrent = CALCULATETABLE(SUMMARIZE(DataFte,DataFte[Office Code],DataFte[EmpId])
                    ,'Date'[Month Number] = 5
                    ,DataFte[Internal] = "Y"
                    ,ALLEXCEPT(DataFte, DataFte[EmpId], DataFte[Office Code]))

VAR ResTable = COUNTROWS(OfficeCurrent) - COUNTROWS( OfficePrevious)

RETURN ResTable