Summing a Measure

[Budfudder]

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 table to allow the user to choose which to see - Renewals or New. Taking into account the value they've chosen, I create a string containing only the applicable products for each invoice, and display the invoices and their corresponding products in a table.

I have a measure that is assigned a value based on a complex filter, which takes into account which of two settings the user has selected as well as the created string, and comes up with a cost for the invoice, including only those products applicable given the user's choice (Renewals or New). I then display this cost on the same row as the invoice. So if the user changes his selection, for each row in the table, the products shown and the cost will both change, including only those products that match the selection.

But I need to be able to show a total value of all of the values shown. How do I sum the measure? If I drag it to the visual, it just shows me one of the figures that are in a row. 

[v-yulgu-msft]

Hi @Budfudder,

Please have a look at this article:

Dealing with Measure Totals

Best regards,

Yuliana Gu

[Zubair_Muhammad]

Hi @Budfudder

Try this pattern

SumofMeasure =
SUMX (
    ALLSELECTED ( TableName[Column_For_Which_Measure_Needs_TO_B_AGRREGATED] ),
    [Measure]
)

[Budfudder]

Unfortunately that didn't work. The result is the same as the cost for each particular row - it's not totalling.