Re: problemas na soma

Tiego · ‎02-20-2017

Boa tarde!

sou novo no PWBI e estou com um problema em um painel.

eu criei uma medida que possui um cálculo e o total dessa medida não soma todos os valores, soma apenas alguns.

Alguém tem uma dica do que pode ser?

parry2k · ‎02-20-2017

If you can explain this in english, I will able to help 🙂

Sorry about that.

Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤

Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Tiego · ‎02-20-2017

Sure,

I have a measure that contains the formula below. In the table, the column total is not adding up all the results as highlighted in the image.

tks

Aumento Sem Venda = IF(
HASONEVALUE(_PercentualZero[Valor])=TRUE();
if(sum(fato_planejamento_venda[Venda Anterior])=0;sum(cliente[Total Limite]);0)*(VALUES(_PercentualZero[Valor]));
0 )

parry2k · ‎02-20-2017

Can you explain what you are trying to achieve?

Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤

Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Tiego · ‎02-20-2017

I am applying a percentage to a value according to a condition.
I need the result to be 1800 + 600 + 131.49 and not just 131.49

parry2k · ‎02-20-2017

so you want % of grand total for each row? if that is the case then you can use in-build quick calc feature. Here is small video on quick calc:

https://www.youtube.com/watch?v=j3ntwX0upQ4

Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤

Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.