Forum Discussion

AstridM's avatar
AstridM
Advocate I
6 years ago
Solved

Distinct Vault per Invoice

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's avatar
    sturlaws
    6 years ago

    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.

2 Replies

  • sturlaws's avatar
    sturlaws
    Resident Rockstar
    6 years ago

    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.