Forum Discussion

bayes's avatar
bayes
Frequent Visitor
8 years ago

Measure SUM returns zero

Hello, I'm trying to create a measure: Amount = CALCULATE(SUM('P&L'[Amount])), where Amount is my column in the query P&L where the data source is a csv file. However, the formula return $0. The same happens when I do Amount = SUM('P&L'[Amount]). This column has a decimal value type. I have no idea why measures don't work. Any ideas?

2 Replies

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    8 years ago

    Hi,

     

    There is no mistake in your second formula.  Share the link from where i can download your PBI file.

  • v-lili6-msft's avatar
    v-lili6-msft
    Community Support
    8 years ago

    Hi@ bayes 

    You can try to set the decimal places of this measure as below:

    Before

     

    After

    If it is not your case, please share your PBIX or csv file.You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading.

     

     

    Best Regards,

    Lin