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
saudansari
2 years agoHelper II
This should work -
TCI = SUMX('Table (2)', 3000000 * 'Table (2)'[DPO])
saudansari
2 years agoHelper II
sabd80 If the DAX worked for you please accept it as a solution.