Roundup a calculated column that has percentage values

[Anonymous]

Hi, I'm hoping someone can help with the below query i have.

I am trying to create a new column in a Dataset table with a basic "ROUNDUP" calculation on another calculated column that has precentages as values, but i keep getting the error message below:

"An argument of function "ROUNDUP" has the wrong data type or the result is too large or too small

Does anyone have any ideas on how to resolve?

Cheers

[StoneRidge]

I am trying to get a 'cost to market' value by multiplying RND_Margin Loss with Qty on Hand.  The values are correct.  But when I try to run the report for a larger date period or more than a few items at a time, PBI presents an error message "Analysis Services: 'An argument of function 'ROUNDUP' has the wrong data type or the result is too large or too small".   I am using an Azure data model with pbi views. I cannot add a column.  My options are to figure this out with DAX.   Below are details and screen shots 

Measures are:  

Standard Gross Profit = [Standard Cost] - [Sales Amount]

Margin Loss = [Standard Gross Profit] / [Standard Cost Amt]

RND_ Margin Loss = ROUND([Margin Loss],2)

Cost to Market =  [Qty on Hand] * [RND_ Margin Loss]

I checked all the data fields are fixed decimals with 2 decimals

Has anyone else had this type of problem with rounding a percentage value?  

[Anonymous · Accepted solution]

For anyone interested, i managed to solve this myself through trial and error. I created a calculated measure in a report (rather than a calculated column in a table) and used MROUND on that measure, this appears to be working 👍

[amitchandak]

@Anonymous , How you have used ?

ROUNDUP([Numeric column], 1)

Tutorial Series for Beginners Part 61: Round, Roundup, and Rounddown: https://www.youtube.com/watch?v=dwMb6zctV2Y&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=61

[Anonymous]

Sadly this does not work. The calculated column that i am trying to round has blanks in it as well as percentage values, not sure if that is an issue?
It seems to be a specific issue with trying to use any ROUND function on this column

[amitchandak]

@Anonymous ,
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[Anonymous]

hey @amitchandak thanks for getting back to me. I have included below an idea of what i am trying to achieve. The final column is the one that i am getting an error message for:

This is the error i am receiving: