Multiple AllEXCEPT

[Anonymous]

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]

Of course!  thank you.

[amitchandak · Accepted solution]

@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])
)
)