Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 !
Solved! Go to 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.
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
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.
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Thank you so much ! 🙂 You make my day !😊
I really need to understand more with the DAX formulas !
Thanks ++