Issue with the ROUND function

Yrstruly2021 — Thu, 25 Jan 2024 14:22:06 GMT

I am geting the error above for these codes. Where am i going wrong?

Dynamic Forecast measure = SWITCH( SELECTEDVALUE(Dynamic_Selection_Period[Period]), "Prediction", "Forecast: " & IF( ISERROR([Time Metric Calculations FCST]), "Error", ROUND([Time Metric Calculations FCST], 2) ) & " (" & IF( ISERROR([Time Metric Calculations CY Forecast] - [Time Metric Calculations FCST]), "Error", ROUND(([Time Metric Calculations CY Forecast] - [Time Metric Calculations FCST]), 2) ) & ", " & IF( ISERROR(([Time Metric Calculations CY Forecast] - [Time Metric Calculations FCST])/[Time Metric Calculations FCST]), "Error", ROUND(([Time Metric Calculations CY Forecast] - [Time Metric Calculations FCST])/[Time Metric Calculations FCST], 2) ) & "%)", "MTD", "Forecast: " & IF( ISERROR([Time Metric Calculations FCST]), "Error", ROUND([Time Metric Calculations FCST], 2) ) & " (" & IF( ISERROR([Time Metric Calculations CY] - [Time Metric Calculations FCST]), "Error", ROUND([Time Metric Calculations CY] - [Time Metric Calculations FCST], 2) ) & ", " & IF( ISERROR(([Time Metric Calculations CY] - [Time Metric Calculations FCST])/[Time Metric Calculations FCST]), "Error", ROUND(([Time Metric Calculations CY] - [Time Metric Calculations FCST])/[Time Metric Calculations FCST], 2) ) & "%)" )

Dynamic Forecast measure = SWITCH(SELECTEDVALUE(Dynamic_Selection_Period[Period]),"Prediction","Forecast: " & ROUND([Time Metric Calculations FCST],2) & " (" & ROUND(([Time Metric Calculations CY Forecast] - [Time Metric Calculations FCST]),2) & ", " & ROUND(([Time Metric Calculations CY Forecast] - [Time Metric Calculations FCST])/[Time Metric Calculations FCST],2) & "%)","MTD","Forecast: " & ROUND([Time Metric Calculations FCST],2) & " (" & ROUND([Time Metric Calculations CY] - [Time Metric Calculations FCST],2) & ", " & ROUND(([Time Metric Calculations CY] - [Time Metric Calculations FCST])/[Time Metric Calculations FCST],2) & "%)")

Re: Issue with the ROUND function

lbendlin — Fri, 26 Jan 2024 01:25:47 GMT

The measures may be BLANK() rather than erroring out.

Re: Issue with the ROUND function

Anonymous — Fri, 26 Jan 2024 06:45:51 GMT

Hi Yrstruly2021

Judging from your error message, the problem is with your Range function.You use the ROUND function to round the result to two decimal places. This should be fine, but you need to make sure that the rounded value is of the numeric type.

If the above suggestions don't help you solve your problem, please provide detailed sample pbix file and the results you expect.So that I can help you better. Please remove any sensitive data in advance.

Best Regards,

Jayleny

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

topic Re: Issue with the ROUND function in DAX Commands and Tips

Issue with the ROUND function

Re: Issue with the ROUND function

Re: Issue with the ROUND function