Forum Discussion
Summing a Measure
I have two tables, Invoices and Products. Each Invoice can have any number (1-n) products. Each product has a tag 'Renewal' or 'New', representing the kind of business they are. I use a third tab...
Hi Budfudder
Try this pattern
SumofMeasure =
SUMX (
ALLSELECTED ( TableName[Column_For_Which_Measure_Needs_TO_B_AGRREGATED] ),
[Measure]
)
Unfortunately that didn't work. The result is the same as the cost for each particular row - it's not totalling.