Forum Discussion
Multiple AllEXCEPT
Hi there,
I am trying to use 2 ALLEXCEPT functions in my measure. It doesn't work - Does anyone have anything I could try?
# Of Job Order ID's (Specific Purpose) =
if(
max('Job Stage (with Total Vacancies)'[Value])="Total Vacancies",
CALCULATE(
[# Of Job Order ID's],
ALLEXCEPT(
'FACT_JobCandidate-Current_LastWeek_Combined',
'FACT_JobCandidate-Current_LastWeek_Combined'[Job Stage],
'FACT_JobCandidate-Current_LastWeek_Combined'[Source Period]
),
ALLEXCEPT(
'Cost Centre',
'Cost Centre'[Cost Centre]
)
),
CALCULATE(
[# Of Job Order ID's],
USERELATIONSHIP('Job Stage (with Total Vacancies)'[Value],'FACT_JobCandidate-Current_LastWeek_Combined'[Job Stage])
)
)
Anonymous , if 'Cost Centre' is a dimension , Try like
# Of Job Order IDs (Specific Purpose) =
if(
max('Job Stage (with Total Vacancies)'[Value])="Total Vacancies",
CALCULATE(
[# Of Job Order IDs],
ALLEXCEPT(
'FACT_JobCandidate-Current_LastWeek_Combined',
'FACT_JobCandidate-Current_LastWeek_Combined'[Job Stage],
'FACT_JobCandidate-Current_LastWeek_Combined'[Source Period] ,
'Cost Centre'[Cost Centre]
)
),
CALCULATE(
[# Of Job Order IDs],
USERELATIONSHIP('Job Stage (with Total Vacancies)'[Value],'FACT_JobCandidate-Current_LastWeek_Combined'[Job Stage])
)
)
2 Replies
- amitchandakSuper User
Anonymous , if 'Cost Centre' is a dimension , Try like
# Of Job Order IDs (Specific Purpose) =
if(
max('Job Stage (with Total Vacancies)'[Value])="Total Vacancies",
CALCULATE(
[# Of Job Order IDs],
ALLEXCEPT(
'FACT_JobCandidate-Current_LastWeek_Combined',
'FACT_JobCandidate-Current_LastWeek_Combined'[Job Stage],
'FACT_JobCandidate-Current_LastWeek_Combined'[Source Period] ,
'Cost Centre'[Cost Centre]
)
),
CALCULATE(
[# Of Job Order IDs],
USERELATIONSHIP('Job Stage (with Total Vacancies)'[Value],'FACT_JobCandidate-Current_LastWeek_Combined'[Job Stage])
)
) - AnonymousNot applicable
Of course! thank you.