Calculated Column Dax variable value being rounded

[Anonymous]

I have a calculated Column that takes 5259 / 3753900 = 0.001400943 However this is being rounded to 0.0014 even when adding extra decimal places it goes to 0.0014000. Here is my dax, ive also gone into modelling to increase the calculated columns decimal places

Below variable is equal to 5259

VAR PerDateCost =

CALCULATE(

SUM(table[cost]) + SUM(table2[cost]),

FILTER(

'Calendar',

'Calendar'[Date] = EARLIER(table[Date])))       // Filter part to only sum one days worth

Below variable equals 3753900

VAR TotalCPUcost =

CALCULATE(

SUM(table[CPUtotal (m)]),

FILTER(

table,

table[ID] = 1 &&

table[Date] = EARLIER(table[Date])

)

)

Below dax then makes the calculation

VAR oneUnitCPU = PerDateCost/TotalCPU

return oneUnitCPU 

[Anonymous · Accepted solution]

i found the issue was with this, when this column was a decimal number it would go back far past 4 decimals, after switching to fixed decimal number currency capped at 4 places.

Top Row Example: 0.4738 actual value

Top Row Example: 0.473840133 actual value

[v-jianboli-msft]

Hi @Anonymous ,

Based on your description, I have created a simple sample:

After my test, it works fine in my side:

Could you please provide more details about your table and your problem such as:

What is the Version of your Desktop?

What is your data source?

What is the connection mode?

Please provide me with more details about your table and your problem or share me with your pbix file after removing sensitive data.

Refer to:

How to provide sample data in the Power BI Forum

How to Get Your Question Answered Quickly

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi, thanks for the reply i am connected to azure storage, i created an export from azure and their costs seem to be capped at 4 decimal places, i can only assume this then carrys through when im doing the calculations