Issue with Rounding in DAX Formula Result

[mdb86]

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. 

In your opinion, how can I resolve this? I have obviously tried adding Round in the formula. 

[mdb86]

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]

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-...

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/1447...

[mdb86]

https://drive.google.com/file/d/15s3RM8hd3MMAt0fdhxPpbdNQSXrKPC8C/view?usp=sharing

[mdb86]

does the link work?

[lbendlin]

Yes, but you provided way too much data. Try to focus on just the issue, remove anything that is unrelated.

I can't see what's wrong 

I noticed you have other round guidelines in place.

[lbendlin]

Please show the formula.

[mdb86]

Pr. = divide([ValoreEsistenza],[Esistenza])

ValoreEsistenza =

 sumx(SUMMARIZE(values(DIM_ART),DIM_ART[CodgrpFis],

                "Esisten", [Esistenza],

           "PrezzoAc", [PrezzomAc]),

    [Esisten]*[PrezzoAc])

Esistenza = VAR entrate= CALCULATE(sum(BODY[Qtàsegno]),

                                    BODY[Segno]="ENTRATE"

                                )

           VAR uscite= CALCULATE(sum(BODY[Qtàsegno]),

                                    BODY[Segno]="USCITE"

                                )

            VAR esist = 'MIS-MAG'[Inventario]+entrate+uscite

           RETURN

    ROUND(esist,2)

PrezzomAc = divide(

                    sum(BODY[ValC]),sum(BODY[QtC]

                    ))

Inventario = CALCULATE(sum(BODY[Qtàsegno]),

                                    BODY[Segno]="INVENTARIO")

Entrate = CALCULATE(sum(BODY[Qtàsegno]),

                                    BODY[Segno]="ENTRATE"

                                )

Uscite = CALCULATE(sum(BODY[Qtàsegno]),

                                    BODY[Segno]="USCITE"

                                )

[lbendlin]

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