total row is the same and wrong

[Anonymous]

Hello. I created this matrix, and inserted these two columns in which there are two measurements namely:

Valore al CMP Nett. Prz con iva = SUM(Aggre_Vend[coe05])*(1+SELECTEDVALUE(Aggre_Vend[Iva_V])/100)

Valore al CMP Nett. Prz = SUM(Aggre_Vend[coe05])

why do I get the same total? what do I need to modify to get the sum of each column? thank you very much!

[Anonymous]

Hi, i'm blocked. Someone can help me? I'm new in power bi thanks!

[Greg_Deckler]

@Anonymous 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

[Anonymous]

Thank you for your response. I tried to adapt what is written in your article but I can't. Could you be more specific on how I could write my functions? thanks!

[amitchandak]

@Anonymous , Try like

SUMX(Aggre_Vend, Aggre_Vend[coe05]*(1+SELECTEDVALUE(Aggre_Vend[Iva_V])/100) )

[Anonymous]

It returns me this erros:

"The resultset of a query to external data source has exceeded the maximum allowed size of ‘1000000’"


what should i fix? thank you!