Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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?
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
Hi,
There is no mistake in your second formula. Share the link from where i can download your PBI file.
User | Count |
---|---|
98 | |
90 | |
84 | |
71 | |
67 |
User | Count |
---|---|
114 | |
103 | |
100 | |
72 | |
64 |