topic Re: Round and divide DAX formula in DAX Commands and Tips

Round and divide DAX formula

EugenioBeltran — Sat, 04 Mar 2023 10:36:17 GMT

Hello, i am looking for a DAX formula that combines divide and round, in example i ha tried round(divide(table1[cases],table1[cases per pallet],0) but it gives me an errors

Thank you for your help

Re: Round and divide DAX formula

andhiii079845 — Sat, 04 Mar 2023 10:42:02 GMT

Do you use this as a measure? This will not work. You use columns without a minx,maxx or sumx...
Or do you use it as a calculated column?

Re: Round and divide DAX formula

EugenioBeltran — Sat, 04 Mar 2023 11:26:46 GMT

I use it as a measure, , row by row

Re: Round and divide DAX formula

EugenioBeltran — Sat, 04 Mar 2023 11:41:50 GMT

It we works if I do =[cases]/[cases per pallet] but it does not work when I add round([cases]/[cases per pallet],0)

Re: Round and divide DAX formula

andhiii079845 — Sat, 04 Mar 2023 12:25:35 GMT

round(divide(table1[cases],table1[cases per pallet],0) a bracket is missing.

round(divide(table1[cases],table1[cases per pallet]),0)

Re: Round and divide DAX formula

v-zhangti — Thu, 09 Mar 2023 05:56:25 GMT

Hi, EugenioBeltran

You can try the following methods.
Sample data:

Measure = ROUND(DIVIDE(SELECTEDVALUE('Table'[Cases]),SELECTEDVALUE('Table'[Cases per pallet])),0)

Measure 2 = ROUND(DIVIDE(SUM('Table'[Cases]),SUM('Table'[Cases per pallet])),0)

Is this the result you expect?

Best Regards,

Community Support Team _Charlotte

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