matrix view
1 Topic
Sumx function isn't working for my view
Hi there, please help me. my sumx function isnt working for a total qty measure i calculated. I have my Qty measure where I am replacing my empty rows with the previous values as such final Qty = VAR CurrentValue = SUM ( data[qty]) VAR PreviousValue = if( sum(data[qty]) = BLANK(), CALCULATE( sum(data[qty]), date[date_dt] = MAX(date[date_dt])-1, )) RETURN if( max(date[date_dt]) =max(date[date_dt]) , CurrentValue + PreviousValue, CurrentValue ) When I put this total on my table view, I dont get the iterative total by the dates as I would like to see. It is giving me the total qty logic as if I was jusr doing a sum(qty). Iterative Qty = sumx(values(date[date_dt]), [final Qty]) (this should add up all the values on the views itself but when I look at it, the rows are correct but the total is still wrong. I had to export it to excel and noticed its not working) Any other way to add my iterative values for my view?Solved988Views0likes4Comments