Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
How can I achieve this?
Hi @ovonel
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.
Based on your description
=
CALCULATE(
[Revenue],
DATESYTD( DATEADD( 'Date'[Date], -1, YEAR ), "5/31" ),
ALLSELECTED( ClientType ),
VALUES( ClientType[FiscalYear] )
)
Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension! |
DAX is simple, but NOT EASY! |
User | Count |
---|---|
125 | |
108 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |