Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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 |
---|---|
77 | |
74 | |
63 | |
61 | |
45 |
User | Count |
---|---|
108 | |
102 | |
93 | |
83 | |
64 |