Forum Discussion

sabd80's avatar
sabd80
Helper IV
2 years ago
Solved

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 = ...
  • Anonymous's avatar
    Anonymous
    2 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