Forum Discussion
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...
Mohammad_Refaei
Solution Specialist
Solution SpecialistYou may try this:
MyMeasure =
CALCULATE (
[Revenue],
DATESYTD ( DATEADD ( 'Date'[Date], -1, YEAR ), "5/31" ),
REMOVEFILTERS ( Table[X] ),
ALLSELECTED ( ClientType[FiscalYear] )
)
Where Table[X] is where you want to remove outside filters.