Forum Discussion
Dealing with Measure Totals
Hi, this is my first post, so apologies if I inadvertently do something wrong. I get the HASONEFILTER trick, but I cannot resolve my formula for the end. I would like my total to be a simple sum of the values above. My example is a purchase price variance sheet.
The basic maths for the rows is Qty x Price, average prices CY vs PY, Qty variance (in Kg), Value Variance (in €) which then breaks out into a "Volume Valued Variance" and then a "Price Variance". I would like the column totals of the PPV column & Vol_Val_Var column to equal the sum of the rows above. It seems like a simple question, but in all of my trawling the solution does not jump out at me...
I would love if anyone could break my deadlock..
Thanks
Paddy
- Ashish_Mathur8 years ago
Super User
Hi,
Share the link from where i can download your PBI file.