Overal Total of total - issue with Running total

[Sky571]

Hello,

I have an issue with the overall total that PowerBI calculate automatically, even if my totals are correct.

Do you know how to change my measures please?

Here is my issue :

The overall total is 344 861.20 wheras my total for supplier 1 is 0 and supplier 2 is 372 430.60

so the overall total should be 372 430.60 and not 344 861.20

Here is my sample pbix :

https://drive.google.com/file/d/1wajr1LyLfzyTY2B4b8kg7_SgOoue3Ew6/view?usp=sharing

Thank you for your help it would be greatly appreciated !

[Jihwan_Kim · Accepted solution]

Hi, @Sky571 

Please try the below measure.

Result total =
IF (
ISFILTERED ( '4 scénarios'[Supplier_Name] ),
IF (
[Running total without debt 60 days] < 0,
0,
[Running total without debt 60 days]
),
SUMX (
VALUES ( '4 scénarios'[Supplier_Name] ),
IF (
[Running total without debt 60 days] < 0,
0,
[Running total without debt 60 days]
)
)
)

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

[Sky571]

@Jihwan_Kim 

Thank you so much ! 🙂 You make my day !😊

I really need to understand more with the DAX formulas !

Thanks ++