Distinct Vault per Invoice

[AstridM]

Hi, 

I have a table where I have the invoiceNumber, the totalAmount, and the itemAmount (and more columns).

I need to get a measure that will give me the totalAmount per invoicenumber. 

I cannot use the sum of itemAmount as it does not include other things like tax.

I do have the total invoice amount and it reaps itself per row and everything I tried does not work unless is only one column chosen.

My data looks like

How can I get

thanks

[sturlaws · Accepted solution]

Hi @AstridM,

try this:

mTotal Amount =
SUMX (
    VALUES ( 'Table'[InvoiceNumber] );
    CALCULATE ( SELECTEDVALUE ( 'Table'[Total Amount] ) )
)

Cheers,
Sturla

If this post helps, then please consider Accepting it as the solution. Kudos are nice too.

[AstridM]

thanks