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...
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