Issue with Sum

Hi Anonymous 

Your judgment condition in IF dax is not clear. Calculate is a calculated value, not a judgment condition. If you run the formula you provide, there is an issue.

What are your judgment conditions? If it is satisfied, what is the value returned? If it is not satisfied, what is the return value? Can you clarify your specific needs ? Or provide your sample ?

I changed your formula, then it can run normally.

UN value =

var _sum=CALCULATE(SUM(Test[Value]),FILTER(ALLEXCEPT(Test,Test[Name],Test[Activity]),Test[check UN]=1))

return IF(Test[check UN]=1,_sum,0)

Best Regards

Community Support Team _ Ailsa Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.