Measure SUM returns zero

[bayes]

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?

[v-lili6-msft]

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

[Ashish_Mathur]

Hi,

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