Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi All
I have below expression working fine.
Solved! Go to Solution.
Hi, @admin11
Sorry, I don't quite understand what you mean. In your pbix, the 1_EXP_SALARY slicer can filter _YTD_EXP_ normally. Why do you still need to insert condition into my _YTD_EXP_ expression?
Maybe you can try formula as below:
_YTD_EXP_1 =
CALCULATE (
SUM ( GL[AMT] ) * 1,
FILTER ( GL, GL[1_EXP] = "EXP" ),
DATESYTD ( 'Date'[Date], "12/31" ),
FILTER ( GL, GL[1_EXP_SALARY] = "Yes" )
)
Best Regards,
Community Support Team _ Eason
Hi, @admin11
Sorry, I don't quite understand what you mean. In your pbix, the 1_EXP_SALARY slicer can filter _YTD_EXP_ normally. Why do you still need to insert condition into my _YTD_EXP_ expression?
Maybe you can try formula as below:
_YTD_EXP_1 =
CALCULATE (
SUM ( GL[AMT] ) * 1,
FILTER ( GL, GL[1_EXP] = "EXP" ),
DATESYTD ( 'Date'[Date], "12/31" ),
FILTER ( GL, GL[1_EXP_SALARY] = "Yes" )
)
Best Regards,
Community Support Team _ Eason
User | Count |
---|---|
98 | |
90 | |
77 | |
71 | |
64 |
User | Count |
---|---|
114 | |
97 | |
95 | |
68 | |
65 |