I have a measure ;
Total Item:=CALCULATE([Total],ALL(Table1),VALUES(Table1[Item]) )
which give a total for items, I would like to replicate this as a calculated column using ALL and Values.
I have got it to work uisng ALLEXCEPT ;
but I cannot get ALL / VALUES to work ; I have tried ;
which I thought would work the same, but I just get an overall total and I've also tried; ;
and I'm not quite sure how this in calculating?
How can I use ALL and VALUES to get the result I want?