Bug on a total ?

[AndreaCBS]

Hi!

I have this problem:

The auto total row on this table, and only for this column, show a number that is not correct. 

I'm probably not seeing the error in front of my nose, so anyone can help me?

Thanks

[Brunner_BI]

What is the expression of your calculation?

[miTutorials · Accepted solution]

You will have to handle the DAX little differently! If you can share your measure, I can try fixing it for you. Meanwhile, Check out the video below.

Incorrect Totals in Power BI ? Watch this | MiTutorials

[AndreaCBS]

The tips in the video fix my problem, thanks for sharing.

[AndreaCBS]

Hi,
this is the meaasure:

 IF (

        ISBLANK([CI_Iva]) || [CI_Iva] = 0,

        0,

        IF (

            [CI_Incassato] + [CI_Dovuto] <> 0,

            DIVIDE([CI_Incassato] * [CI_Iva], [CI_Incassato] + [CI_Dovuto], 0)

        )

    )

THanks in advance, I will watch the video that you link


@Brunner_BI @miTutorials