total row is the same and wrong

Question

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!

amitchandak · Answer

Anonymous , Try like 
&nbsp;
SUMX(Aggre_Vend, Aggre_Vend[coe05]*(1+SELECTEDVALUE(Aggre_Vend[Iva_V])/100) )

greg_deckler · Answer

Anonymous&nbsp;First, please vote for this idea: https://ideas.powerbi.com/ideas/idea/?ideaid=082203f1-594f-4ba7-ac87-bb91096c742eThis 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/63376Also, 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/547907Also: https://youtu.be/uXRriTN0cfYAnd: https://youtu.be/n4TYhF2ARe8

anonymous · Answer

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!

anonymous · Answer

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!

anonymous · Answer

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

Forum Discussion

total row is the same and wrong

5 Replies

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

what should i fix? thank you!

Related content

Wrong Total

Wrong Total in Table

Wrong total

wrong total

Total measures show wrong total when report is published