Forum Discussion
sabd80
2 years agoHelper IV
DAX wrong total
Hi, I have the measure (Testing Step 2 Cash Improvement ) that gives a wrong total, the total should be 684,507, but it is giving 691,141. This the dax: Testing Step 2 Cash Improvement = ...
- Anonymous2 years ago
Hi sabd80,
Here are some steps you can follow to troubleshoot the issue:
Here are my test data:
1.Create a measure
Testing Step 2 Cash Improvement = ROUNDUP ( SUMX ( SUMMARIZE ( 'Supplier Spend Analysis', 'Supplier Spend Analysis (2)'[3.Step 2 DPO Days Move Each Supplier] ), 3000000 * 'Supplier Spend Analysis (2)'[3.Step 2 DPO Days Move Each Supplier] ), 0 )2.Final output
In order for you to solve the problem faster, you can refer to the following documentation
How to Get Your Question Answered Quickly - Microsoft Fabric Community
Best Regards,
Albert He
ALLUREAN
2 years agoSolution Sage
Try this one:
Testing Step 2 Cash Improvement = SUMX('Supplier Spend Analysis', 3000000 * [3.Step 2 DPO Days Move Each Supplier])
sabd80
2 years agoHelper IV
that did not work, the supplier code should be the same.
- saudansari2 years agoHelper II
This should work -
TCI = SUMX('Table (2)', 3000000 * 'Table (2)'[DPO])- saudansari2 years agoHelper II
sabd80 If the DAX worked for you please accept it as a solution.