Totals from measured column are not adding up in Table. Individual rows are correct.

[efstel]

Totals from measured column are not adding up.  Individual rows are correct. 

Here's the measure for the revenue column:

Revenue =

MIN([ContractOverrideWIP], IF([Contract Override minus ECAC Override] < 0, [Contract Override minus ECAC Override] + [ActualCost], [ContractOverrideWIP] * [WIP%Complete]))

and the underlying measures:

ContractOverrideWIP = SUM(WIP[Contract Override])

Contract Override minus ECAC Override = SUM('WIP'[Contract Override]) - SUM('WIP'[ECAC Override])

ActualCost = SUM(JCCD[ActualCost])

WIP%Complete = DIVIDE(SUM('JCCD'[ActualCost]), SUM('WIP'[ECAC Override]))

Any suggestions on what is going on?

[Jihwan_Kim · Accepted solution]

Hi,

I am not sure how your semantic model looks like, but please try something like below and check whether it works.

Revenue =
SUMX (
    VALUES ( TableName[JobNo] ),
    MIN (
        [ContractOverrideWIP],
        IF (
            [Contract Override minus ECAC Override] < 0,
            [Contract Override minus ECAC Override] + [ActualCost],
            [ContractOverrideWIP] * [WIP%Complete]
        )
    )
)

[Anonymous · Accepted solution]

Hi @efstel ,

Base on your description, it seems like you can't get the correct total Revenue in the visual. You can create another new measure as below to replace the original one on the visual. Later check if it can return the expected result.

Measure = SUMX ( VALUES ( 'Table'[JobNo] ), [Revenue] )

In addition, you can refer the following links to try to solve your problem...

Why Your Total Is Incorrect In Power BI - The Key DAX Concept To Understand

Dax for Power BI: Fixing Incorrect Measure Totals

If the above one can't help you figure out, please provide some raw data in your tables(exclude sensitive data) with Text format and your expected result with backend logic and special examples. It would be helpful to find out the solution. You can refer the following link to share the required info:

How to provide sample data in the Power BI Forum

And It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.

How to upload PBI in Community

Best Regards

[Jihwan_Kim · Accepted solution]

Hi,

I am not sure how your semantic model looks like, but please try something like below and check whether it works.

Revenue =
SUMX (
    VALUES ( TableName[JobNo] ),
    MIN (
        [ContractOverrideWIP],
        IF (
            [Contract Override minus ECAC Override] < 0,
            [Contract Override minus ECAC Override] + [ActualCost],
            [ContractOverrideWIP] * [WIP%Complete]
        )
    )
)