Sum index column rather than use Grand Total

[tourgis2000]

Hi all,

I'm aware that similar questions have been asked before on this topic and that the answer seems to require SUMX and VALUE, but I would be grateful for some insight:

My index column, here called 'Unit Price(weighted) at Old Number', is the result of a number of helper measures so I can't see how I can use Columns for the SUMX calculation. here's an example:

Can anyone help with how to craft a measure that sums the column 'Unit Price(weighted) at Old Number' rather than aggregated with Grand Total?

Many thanks,

Martin

 

[Jacob Barnett]

The way to approach it is to use 2 measures, one to do the basic calc and the other to iterate it. I can't satisfactorily explain why you need to iterate a separate measure or why it gives a different result but it does. Assuming your table is called 'table1':

[Measure 1]=SUM(Table1[Unit Price])*SUM(Table1[Number Per Old])

[Measure 2]=SUMX(VALUES(Table1[Type]),[Measure 1])

Hope this helps.