Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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

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

  • Anonymous's avatar
    Anonymous
    Not applicable

    Of course!  thank you.