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.
I have a table for people who have applied for, been accepted for, and attended a thing. I started with...
Solved! Go to Solution.
2 filters inside the same CALCULATE are applied as an AND condition, in case of 2 filters inside nested CALCULATE the filter context generated by inner CALCULATE will overwrite the filter context generated by outer CALCULATE.
Your outer CALCULATE generated a filter context where Interactions[Attended] = TRUE() but the inner CALCULATE generates the filter context where Interactions[Attended] is not blank and this is why the inner CALCUALTE nullifies the effect of the filter context generated by the outer CALCULATE and at the end you get the result for Attended not blank
Attended =
CALCULATE (
CALCULATE (
[Applications],
NOT ( ISBLANK ( Interactions[Attended] ) ) -- This overwrites the Filter context
-- generated by outer CALCULATE on the same
-- column
),
Interactions[Attended] = TRUE () -- The filter context generated here is overwritted by the
-- filter context create by the inner CALCULATE
)
2 filters inside the same CALCULATE are applied as an AND condition, in case of 2 filters inside nested CALCULATE the filter context generated by inner CALCULATE will overwrite the filter context generated by outer CALCULATE.
Your outer CALCULATE generated a filter context where Interactions[Attended] = TRUE() but the inner CALCULATE generates the filter context where Interactions[Attended] is not blank and this is why the inner CALCUALTE nullifies the effect of the filter context generated by the outer CALCULATE and at the end you get the result for Attended not blank
Attended =
CALCULATE (
CALCULATE (
[Applications],
NOT ( ISBLANK ( Interactions[Attended] ) ) -- This overwrites the Filter context
-- generated by outer CALCULATE on the same
-- column
),
Interactions[Attended] = TRUE () -- The filter context generated here is overwritted by the
-- filter context create by the inner CALCULATE
)
@tonylee , try if this gives you 137
Attended = CALCULATE ( [Places Allocated], filter(Interactions,Interactions[Attended] = TRUE() ))
if so, overlap filter can be an issue.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
70 | |
36 | |
21 | |
18 | |
15 |
User | Count |
---|---|
126 | |
30 | |
28 | |
24 | |
22 |