Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
76 | |
64 | |
63 |
User | Count |
---|---|
142 | |
105 | |
102 | |
80 | |
67 |