Issue with Rounding in DAX Formula Result

Question

Hello, I have an issue with rounding a number. It concerns the Pr. field (DAX measure).Even if I set the detail to the sixth decimal place, the rounding stops at the fourth, adding "00" at the end.&nbsp;In your opinion, how can I resolve this? I have obviously tried adding Round in the formula.&nbsp;&nbsp;

lbendlin · Answer

Please show the formula.

mdb86 · Answer

Pr. = divide([ValoreEsistenza],[Esistenza])&nbsp;ValoreEsistenza =&nbsp;sumx(SUMMARIZE(values(DIM_ART),DIM_ART[CodgrpFis],&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "Esisten", [Esistenza],&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;"PrezzoAc", [PrezzomAc]),&nbsp; &nbsp; [Esisten]*[PrezzoAc])&nbsp;Esistenza = VAR entrate= CALCULATE(sum(BODY[Qtàsegno]),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; BODY[Segno]="ENTRATE"&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; )&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;VAR uscite= CALCULATE(sum(BODY[Qtàsegno]),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; BODY[Segno]="USCITE"&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; )&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; VAR esist = 'MIS-MAG'[Inventario]+entrate+uscite&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;RETURN&nbsp; &nbsp; ROUND(esist,2)&nbsp;PrezzomAc = divide(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; sum(BODY[ValC]),sum(BODY[QtC]&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ))&nbsp;Inventario = CALCULATE(sum(BODY[Qtàsegno]),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; BODY[Segno]="INVENTARIO")Entrate = CALCULATE(sum(BODY[Qtàsegno]),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; BODY[Segno]="ENTRATE"&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; )Uscite = CALCULATE(sum(BODY[Qtàsegno]),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; BODY[Segno]="USCITE"&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; )

lbendlin · Answer

I would guess that&nbsp;&nbsp;ROUND(esist,2)&nbsp; plays a role.&nbsp; But maybe you want to spend some time refactoring that query. It seems to be rather complex.

mdb86 · Answer

I understand your point. It's hard to understand the logic outside power Bi. I'd like to share an example but I don't know how to do, can you help me, this way it would be easier for the comunity to check the formulas.
Thank you very much

lbendlin · Answer

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

Forum Discussion

Issue with Rounding in DAX Formula Result

8 Replies

Related content

Rounding

If formula

Power query formula for adjusting rounding in columns - Multi input

formula

DAX Formula Help