Help with a measure for total value. It is not totaling out in the grand total correctly

[mdhenzel]

Hi all,

I am having issues with a measure that is taking a column value and multiplying by a measure. The individual rows have come out correctly, but due to the way I have written the meausre, it isn't totaling correctly. In the below, the total value is taking the std. cost (a column) and multiplying against the total units (a measure). Issue is, the grand total. This version is using firstnonblank for std cost. If I use sum for std cost, the total comes out in the billions. it should be around 31 million. Any help? 

[v-zhangti · Accepted solution]

Hi, @mdhenzel 

You can try the following methods. IF(HASONEVALUE()) can control the output of Total value.

Measure

Total Value = 
IF (
    HASONEVALUE ( 'Table'[ID] ),
    SUM ( 'Table'[Std. Cost] ) * [Total Units],
    SUMX (
        SUMMARIZE (
            'Table',
            'Table'[ID],
            "Sum", SUM ( 'Table'[Std. Cost] ) * [Total Units]
        ),
        [Sum]
    )
)

Is this the result you expect?

For reference: Solved: How to find the sum of multiple averages - Microsoft Power BI Community

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.