Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
@Yip , 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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |