Error en el total

[J3]

Hola, tengo la siguiente medida en Dax 

Electricidad Esperada =

Var x=  CALCULATE(SUM('1  BBDD Energía'[Grados días 18°]),OR(YEAR('1  BBDD Energía'[Fecha])=2023,YEAR('1  BBDD Energía'[Fecha])=2024))

var y  = x*[Coeficiente_grados] + [Intercepto_grados]

RETURN y

y al hacer un tabla con la medida, me da un error en el total, como puedo solucionarlo? 

[Greg_Deckler · Accepted solution]

@J3 First, please vote for this idea: https://ideas.powerbi.com/ideas/idea/?ideaid=082203f1-594f-4ba7-ac87-bb91096c742e

This looks like a measure totals problem. Very common. See my post about it here: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376

Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907

Also: https://youtu.be/uXRriTN0cfY
And: https://youtu.be/n4TYhF2ARe8

[v-xinruzhu-msft · Accepted solution]

Hi, 

Thanks for the solution @Greg_Deckler  provided, and i want to offer somre more information for user to refer to.

hello @J3 , basd on your description, you can create a new measure.

e. g 

Sum_Electricidad Esperada =
SUMX ( VALUES ( '1  BBDD Energía'[Mes] ), [Electricidad Esperada] )

Then put the new measure to the visual.

Best Regards!

Yolo Zhu

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

[Greg_Deckler · Accepted solution]

@J3 First, please vote for this idea: https://ideas.powerbi.com/ideas/idea/?ideaid=082203f1-594f-4ba7-ac87-bb91096c742e

This looks like a measure totals problem. Very common. See my post about it here: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376

Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907

Also: https://youtu.be/uXRriTN0cfY
And: https://youtu.be/n4TYhF2ARe8