Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
Hi Anonymous
Thanks for reaching out to us.
>> And then calculate the addition with the max values
You can try this, create the 2 measures
Max_PerMarDes =
var _maxEta=CALCULATE(MAX('Table'[Etapa1]),ALLEXCEPT('Table','Table'[Market],'Table'[Despatch]))
return IF(MIN('Table'[Etapa1])=_maxEta,_maxEta)sum = SUMX('Table',[Max_PerMarDes])
result
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.