CALCULATETABLE returns error " a table of multiple values was supplied where single value expected"

[SBR1D]

Hi All

The following code is returning the error in the title but i've only specified one column so i don't know why?

lapsed employers v2 = VAR LAPSEDTBL = CALCULATETABLE(SUMMARIZE('Learning Plan','Learning Plan'[Employer Name]),
'Learning Plan'[Status Desc]= "In Progress")
RETURN
 CALCULATETABLE(SUMMARIZE( 'Learning Plan','Learning Plan'[Employer Name]),                                                                                                                                                                                
NOT 'Learning Plan'[Employer Name] IN LAPSEDTBL)  

[SBR1D]

Thank you that works great.

[Ahmedx]

or 
Table2 lapsed employers v2 =
VAR LAPSEDTBL1 =
    
        SUMMARIZE ( 
                    FILTER ('Learning Plan','Learning Plan'[Status Desc] = "In Progress")
                       , 'Learning Plan'[Employer Name] )
VAR LAPSEDTBL2 = SUMMARIZE ( FILTER ('Learning Plan','Learning Plan'[Employer Name] )
RETURN
    
        EXCEPT(LAPSEDTBL2,LAPSEDTBL1)

[Ahmedx]

this returns a table, but not a scolar value. that's why the error comes out

what do you want to receive?

[SBR1D]

Thanks for the quick reply. I want to see a the emploeyer names not in LAPSEDTBL.  I thought a calculatedtable would be fine for that or can you not use calculatedtable with return?

[Ahmedx · Accepted solution]

pls try this

Table1 lapsed employers v2 =
VAR LAPSEDTBL =
    
        SUMMARIZE ( 
                    CALCULATETABLE ('Learning Plan','Learning Plan'[Status Desc] = "In Progress")
                       , 'Learning Plan'[Employer Name] )
RETURN
    
        SUMMARIZE ( 
            CALCULATETABLE ('Learning Plan',NOT 'Learning Plan'[Employer Name] IN LAPSEDTBL)
               'Learning Plan'[Employer Name] )
-----------------
or 
Table2 lapsed employers v2 =
VAR LAPSEDTBL =
    
        SUMMARIZE ( 
                    FILTER ('Learning Plan','Learning Plan'[Status Desc] = "In Progress")
                       , 'Learning Plan'[Employer Name] )
RETURN
    
        SUMMARIZE ( 
            FILTER ('Learning Plan',NOT 'Learning Plan'[Employer Name] IN LAPSEDTBL)
               'Learning Plan'[Employer Name] )