Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredJoin 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.
Does anyone knows how to write in DAX to tell power bi to add up all of the values in the range of cells that is determined by the value of the cell "LT" in the same row
@Anonymous , Please check the reply from @TomasAndersson first. If that does not help .
I think double = is causing it
for var you need code like
=
var _variable = sumx(Table, [Value])
return
_variable
Hi!
If you are able to change the structure of your data the easiest way would be to make your table long instead of wide so that you only have four columns, "Demand...", "LT", "Variable","Value".
You can do that in Power Query if you go to the model view, select Edit query and then under Transform select "Unpivot columns" with all your columns with values selected:
If you control your data source you might be able to do it there as well.
Then you could only use a simple SUM(Value) to find the totals.
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the October 2025 Power BI update to learn about new features.
User | Count |
---|---|
82 | |
42 | |
31 | |
27 | |
27 |