Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Why ALLSELECTED(ALLEXCEPT ( ClientType, ClientType[FiscalYear] )) doesnt work?

I am trying to build the measure:

 

CALCULATE([Revenue] ,

                      DATESYTD(dateadd('Date'[Date],-1,Year),"5/31"),

                      ALLSELECTED(ALLEXCEPT ( ClientType, ClientType[FiscalYear] ))

            

)

 

Unfortunately ALLSELECTED is not allowed nested with an ALLEXCEPT.

 

  • I need the ALLSELECTED, so I can ignore the filter in the current query.

 

  • I need the ALLEXCEPT, because I need to ignore a filter from outside on another column, but I do want to preserve the outside filter on FiscalYear!

 

How can I achieve this?

 

Need Help

2 Replies

  • CNENFRNL's avatar
    CNENFRNL
    Community Champion
    4 years ago

    Based on your description

    =
CALCULATE(
    [Revenue],
    DATESYTD( DATEADD( 'Date'[Date], -1, YEAR ), "5/31" ),
    ALLSELECTED( ClientType ),
    VALUES( ClientType[FiscalYear] )
)
  • v-jingzhang's avatar
    v-jingzhang
    Community Support
    4 years ago

    Hi Anonymous 

     

    It seems ALLEXCEPT is enough. It can remove filters except for the specified column filters. How about using below code?

    CALCULATE (
    [Revenue],
    ALLEXCEPT ( ClientType, ClientType[FiscalYear] ),
    DATESYTD ( DATEADD ( 'Date'[Date], -1, YEAR ), "5/31" )
)

     

    Regards,
    Community Support Team _ Jing
    If this post helps, please Accept it as Solution to help other members find it.