Can you able to help us identify and fix the issue for this formula ?

[sivashankr]

Hi ,

[lbendlin]

What's the expectation? Do you want to see the average?

[sivashankr]

HI

[mahoneypat]

You can use this DAX pattern to solve issues like these to get the expected "total" (totals are not totals, but just the result of your expression evaluates without the context provided by each of the "rows" in the table.

NewMeasure = SUMX(Values(Table[ColumnInYourVisual]), [_DaysWeightedAverageTemp])

Use the above type measure in your table.  The rows and the total should give the expected results.

If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat

[lbendlin]

use the IF(HASONEVALUE()) construct to differentiate between the caclulation for the visual rows and for the totals.

[parry2k]

@sivashankr is this a measure? If yes what is the expression? if it dependent on other measures, what is their expressions?