Forum Discussion

preetha_127's avatar
preetha_127
Frequent Visitor
6 years ago
Solved

undefined

Hi Team, I have same multiple invoice id with different invoice amount.I want sum those invoice amount against one invoice.  
Dashboards
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    6 years ago

    Hi preetha_127, 

     

    You can create a calculated column and measure like below: 

     

    InvoiceNew = LEFT('Table'[Invoice],3)
     
    TotalByInvoice = CALCULATE(SUM('Table'[Invoice amount]),FILTER('Table','Table'[InvoiceNew]=MAX('Table'[InvoiceNew])))
     

     

     

    Best Regards,
    Qiuyun Yu

v-qiuyu-msft's avatar
v-qiuyu-msft
Community Support
6 years ago

Hi preetha_127, 

 

You can create a calculated column and measure like below: 

 

InvoiceNew = LEFT('Table'[Invoice],3)
 
TotalByInvoice = CALCULATE(SUM('Table'[Invoice amount]),FILTER('Table','Table'[InvoiceNew]=MAX('Table'[InvoiceNew])))
 

 

 

Best Regards,
Qiuyun Yu