Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 ++
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
26 | |
19 | |
14 | |
10 |
User | Count |
---|---|
58 | |
50 | |
44 | |
19 | |
18 |