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!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
Hey All;
I'm in need of a hand with adding/subractiing measures. Two is no problem. However, I have 4 measures that I want to get the total of.
Did some digging around, however I can't get sum or sumx to work. they error every time. Any assist would be great.
Sum = [Measure1] +[Measure2] + [Measure3] + [Measure4]
Or
Sum = Sumx(Table,[Measure1] +[Measure2] + [Measure3] + [Measure4])
or
SumX(Values(Table[Value]), [Measure1] +[Measure2] + [Measure3] + [Measure4] )
or
SumX({ [Measure1] +[Measure2] + [Measure3] + [Measure4]}, [Value] )