Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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)
Solved! Go to 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] )
Thank you that works great.
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)
this returns a table, but not a scolar value. that's why the error comes out
what do you want to receive?
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?
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] )
User | Count |
---|---|
96 | |
86 | |
78 | |
72 | |
67 |
User | Count |
---|---|
110 | |
104 | |
84 | |
65 | |
63 |