Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

See when key Fabric features will launch and what’s already live, all in one place and always up to date. Explore the new Fabric roadmap

Reply
Tiego
Frequent Visitor

problemas na soma

‎02-20-2017 08:00 AM

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?

PWBI.PNG

Labels:
Message 1 of 6
2,949 Views
0
5 REPLIES 5
parry2k
Super User
Super User

‎02-20-2017 10:09 AM

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.

Message 2 of 6
2,934 Views
0
Tiego
Frequent Visitor
In response to parry2k

‎02-20-2017 10:14 AM

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 )

 

Message 3 of 6
2,931 Views
0
parry2k
Super User
Super User
In response to Tiego

‎02-20-2017 10:15 AM

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.

Message 4 of 6
2,929 Views
0
Tiego
Frequent Visitor
In response to parry2k

‎02-20-2017 10:19 AM
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
Message 5 of 6
2,927 Views
0
parry2k
Super User
Super User
In response to Tiego

‎02-20-2017 10:23 AM

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.

Message 6 of 6
2,925 Views
0

Helpful resources

Announcements
May PBI 25 Carousel

Power BI Monthly Update - May 2025

Check out the May 2025 Power BI update to learn about new features.

May 2025 Monthly Update

Fabric Community Update - May 2025

Find out what's new and trending in the Fabric community.

View All