How to get first row measure value

Good morning! QQ for you all. We have a report with a calculated measure that is adding up hours spent, works great. However, once we put a time filter on it, it still adds from before the filter. We are fine with just subtracting the value from the first row but we can’t figure out how to access that. We assumed you could use item(0) or something like that but it doesn’t work. Any ideas? To summarize, in our time dimension, how to reference the first row of our dataset, specific measure value. Thank you!

I would very much like to solve for this as well

Hi @drone

You can use the regular Hours spent measure and select Add calculatedCumulative sum for this column which will create a new column that generates the cumulative sum of your selected column’s visible rows.

Best regards,
Nauris / eazyBI support

Beautiful. Thank you so much. Exactly what I was looking for!