Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 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, ClientTy...
Need Help
v-jingzhang's avatar
v-jingzhang
Icon for Community Support rankCommunity Support
5 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.