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
CNENFRNL's avatar
CNENFRNL
Icon for Community Champion rankCommunity Champion
5 years ago

Based on your description

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