Forum Discussion

AstridM's avatar
AstridM
Icon for Advocate I rankAdvocate 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 ca...
  • 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.

sturlaws's avatar
sturlaws
Icon for Resident Rockstar rankResident 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.

AstridM's avatar
AstridM
Icon for Advocate I rankAdvocate I
6 years ago

thanks