topic Re: Numerical formats in DAX Commands and Tips

Numerical formats

Anonymous — Fri, 12 Jun 2020 05:23:47 GMT

Hello All,

I am using dax measure to calculate the result for division of two counts for two columns, the issue that I always got an integer approximated result ( for example when the actual division result is 0.68 I got 1)!!

how can we change the result numeric format to show the exact value without approximation to nearest integer? Thank you

Re: Numerical formats

Anonymous — Fri, 12 Jun 2020 05:31:05 GMT

Hi Anonymous ,

Select your measure and go to the ribbon above . Click on the dropdown and select Decimal Number

Regards,
Harsh Nathani

Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

Re: Numerical formats

Anonymous — Fri, 12 Jun 2020 05:52:29 GMT

This is not working!! The result is still Integer!!
I can change the format to each one of this but it is only applied to the integer value for example 1, 1,00, 100%, 100.00% ... etc. The problem is in the Dax code that did the approximation!!
I have these values for the different counts of two columns: 1024 & 860.
so 860/1024=0.839

I got 1 & not 0.839. I hope it is now clear.

Re: Numerical formats

Anonymous — Fri, 12 Jun 2020 05:59:10 GMT

Hi Anonymous ,

Not sure why are you getting 1. This is what I get.

Regards,
Harsh Nathani

Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

Re: Numerical formats

Anonymous — Fri, 12 Jun 2020 15:49:23 GMT

you are here used simply two numbers, I am using Dax calculation to divide the result of a count statement for a column by a count statement for another column!! Which didn't give me the ax act result without approximation!

Re: Numerical formats

Anonymous — Fri, 12 Jun 2020 16:10:22 GMT

Hi Anonymous ,

Dividing 2 measures also give me the formatting. Not sure why it is not showing up in your pbix.

Result1 =

var _a = FILTER(ALLEXCEPT('Table2','Table2'[Bank]), 'Table2'[ErrorType] <> BLANK())

RETURN

CALCULATE(DISTINCTCOUNT('Table2'[Process]),_a)

Result2 = CALCULATE(DISTINCTCOUNT('Table2'[Process]),ALLEXCEPT('Table2','Table2'[Bank]))

DivideVal = DIVIDE([Result2],[Result1])

Below image is for

DivideVal = DIVIDE([Result1],[Result2])

Thanks

Re: Numerical formats

Anonymous — Sat, 13 Jun 2020 20:20:33 GMT

Re: Numerical formats

Anonymous — Sat, 13 Jun 2020 16:08:29 GMT

Hi Anonymous ,

Shown both the division in the above post.

Can you share some sample data and the measure formula for TAT Order and Typical Submission

Regards,

Re: Numerical formats

Anonymous — Sat, 13 Jun 2020 20:19:43 GMT

It was my fault, I was forget one filter active, now everything is working. Thank you for your cooperation