OMG... you saved my life... everyone has told me Pareto don't exist in PBI... you made it happen we use them all the time !!! Thank you once again soooo very much!!! 💖
Thanks you so much, you saved me for another day of work trying to figure out what to do :D , after 3 days of looking at so many tutorial, this is THE MOST effective and efficient.
Gracias, Thank You, Merci!! You saved my month! I've been looking for this solution for weeks with no success. Now is clear. I loved also the article from Matt. I just had to adapt the DAX formulas, since my report pages is already pre-filtered by a "main" page, so I have to use ALLSELECTED( to keep the right records. This is the first comment I write on your videos, although I like many of them. In summary, great work Ruth, keep moving!
Great video! I really appreciate you going through the differences when using time and other ranking. And your use of TOPN is just brilliant. I didn't see that in any of the other posts and videos that I've found. Thank you!
Thanks for sharing the video, 5 month before I struggled a lot to solve this , had to read a lot of blogs on PowerBI community and finally got the solutions. this video will help a lot of people.
Hey Ruth, it's already like with Pavlov reflex .. when I see Dax Friday it's the moment where I start my weekend :-) and actually this topic is again very interesting and cool explained 👍🏻🎉 have a great weekend and greeting !
+SmartBimson Hi SmartBimson! I didn't know what the Pavlov reflex was... until now! 😂 Oh Dear... think if I miss one Friday! 😱 Thanks for all your support and have a great weekend too! You make my Fridays w your comments:) /Ruth
after a week of tryinig to figure it out found this video and it really helped, I did a few tweeks acording to my business case but tis helped me a lot, muchas gracias
Hi Ruth, I used exactly the formula you included here for the cumulative by date, only my table and columns have different names. The underlying data is the same, and I don't get a running sum, it's the Total Tooling Sales measure duplicated. Here's my DAX: Running Sales = CALCULATE([Total Tooling Sales], FILTER(ALL(ToolingOrders[Date]), ToolingOrders[Date]
Hi Ruth , great video. I just came up with that one where running totals is worked out without ranking and summing up sales without dates: SUMX( FILTER( SUMMARIZE(ALLSELECTED(sales),sales[item],"TOTALSALES",[Sum Sales]), [TOTALSALES]>=CALCULATE([Sum Sales],VALUES(sales[item]))), [Sum Sales]) Here "Values" is essential inside calculate as it retrieves the initial filter context of the pivot , and get out of the summarized table filter context in order to compare the total sales of the summarized table and current sales of the pivot . I would appreciate your comment. Dave.
I've learned so much from these videos, thank you so much for producing these. My question is what if i want to exclude the first 2 dates from the running total?
Hi Ruth. Another great video. DAX Fridays! are really awsome! Running Total is a really interesting topic and very useful. Moving Annual Total and Moving Average could be further interesting topics. Best regards.
i don't understand the cumulative when there are TIES. Its not truly doing a running total for each product, right? It groups all the ties together. Is that how it is supposed to work?
Thank you very much. I've been using CALCULATE/DATESYTD in my running totals, but always got some bugs, specially when I use tables. Now the problem is all sorted out.
Hi Ruth, i wanted to create running totals for Current (2019) and Previous (2018) Years and show them in line chart with Short Month name. Cumulative Incident 2018 = CALCULATE([2018], Filter(ALLSELECTED(CalendarTable), CalendarTable[Date]
Hi Ruth and Curbal community. This is a great video that accomplishes the result with very few steps (I've seen others that make the calculation more cumbersome). I´m trying to complement the graph with a card visual that shows how many items represent < = 80% of sales, in the video for instance the value would be 4. I'm doing a calculation combining distinctcount with a filter (pareto % < = 0.8) but having trouble getting to the desired result on my report, any help will be welcomed and appreciated.
In the running total using rank, I see two values in the with 3rd rank and for item No. 6 it does not add the previous total. How do we overcome this? can you please explain?
Hello Mam - In which video you have clear the concept of Filter in your running total. Could you please share that link where in you spoke about 30 minutes.
I love your videos. Dax Friday is great! I wonder how to calculate a cumulative sum of demand until it meets/exceeds inventory then it stops cumulative. It’s a challenge for me but maybe I am overthinking it
Pls do a video on Pareto chart Requirement: we have 2300 customers whose whose sales Loss/Profit vary from -2500000 to 4500000 USD in a FY in a company. I want to show bottom most customers contributes to the business by using Pareto Chart. Pls explain.
Hi Ruth, Thank you for your videos. I am constantly referring in order to deliver quality dashboards at work! I notice a flaw in this logic: Referring tto 11:30 & 12:10. Row 3 & 4 are not actually getting added. Row 3 should be 41279 and row 4 should be 54914. Instead we have only one of those two values depending on your DAX formulae. The cumulative total doesn't seem to work in case of a tied rank. Am I missing something ??!
Thanks for sharing videos. it's helping me a lot. I have one scenario, please help me on that. The scenario is, where we have to show cumulative for distinct count of IDs on year -Month. And it should display for last 12 months, however count should be taken from beginning of the date and it will filter the data based on slicer or filters. Please let me know, if you need more details on it. Thanks very much in advance.
Hi, thank you so much for the hard work and nice tips you provide! May I ask a question concerning the rank 3 item which is not included in the cumulative sum since both of items are ranked n°3 . We see that at the end of the video.
Hi I have a question what would be a syntax I will have to use if i need to have a % of increase in volume month on month. I cant add a new column since I use a live connect. I have a Column with the volume and another Column with Month. So I need a see what is the percentage of increase or decrease in volume from previous month.
HI Daniel, They are not the same. Today() will give you today's date while MAX(Date) will give you the last value on your date column. That is not always today's date :) Hope I explained myself! /Ruth
Hi Curbal - Big fan of your videos. Wanted to check if we can do opening balance and closing balance calculation for dataset having missing periods (months) which is very common when there are no stock movements? I tried using following calculations but these doesn't work when there are no stock movement for any period. Opening Balance = OPENINGBALANCEMONTH([RunningTotal_CBQ] , Inventory[PERIOD]) --Closing Balance Formula as RunningTotal RunningTotal_CBQ = CALCULATE(SUMX(Inventory , [Total_Qty]) ,FILTER(ALL(Inventory[PERIOD]) , Inventory[PERIOD]
Hi Ruth, thanks for the great videos with great explanations, is very helpful all the time. I have a bit of an issue here. I have a dataset where I have a cumulative count. have 3 categories as country, state and city (which are also in the report). where I need to get the latest value of the count (max) and also when no item is selected need to show the sum of the maximum values....How can this be achieved...Please need help.Thank you so much in advance
Hi Ruth, I have one question about running total. I have used All and all selected functions for getting running total. I received the same result. Please explain me the difference between them.
Hi Ruth Thanks for the informative video. I feel if we cannot break the tie in the ranking, then the pareto chart will give the wrong line chart as the % will remain constant across categories having the same values. Since you are saying there is no way to break the tie in power BI, I feel it is better we don't create a pareto chart in powerBI
+Gopa Kumar Here is one way to break ties: m.th-cam.com/video/kRtmb8ftyQc/w-d-xo.html If you don't need a specific criteria for how you break the ties, it works! /Ruth
Thank you. But can we use that measure in TOPN to get the cumulative total over each and every category? when I tried replacing the normal ranking with the normal ranking + rand in TOPN, the cumulative total is not giving the correct values.
Hi Madam, I am watching fantastic full of information packages. But i stuck in one senerio can't find help. Would you please assist me. Suppose we have products A,B and C which are ordering in a month different days. I want running total of all product each month. Next month running start again means running total for each month not all 3 months. I want solution in DAX. I can calculate running total of 3 months but can't each month. Thanks in advance
Hi Ruth, how about to have different ranks even for same "sales" ? Otherwise I think we would have a longer pareto because we are not making a distinction between items with same sales.
Hello Rut, great videos. I have a question how don't stay number repeats, in percent ? Example Item 4 = 71% Item 6 = 71% Sorry my english, i don't speak very well !
Hey Ruth, i noticed that running sales other has a wrong total when you are calculating it for items. How to correct it or else give the idea if i completely want to remove that grand total. Because in other viz i also facing the same situation where i dont need grand total but still it appears.
To "remove" grand total in the visualisation, you can use field formatting (select the field - Font and background color: white - apply only to total) The grand total for the field will disappear.
Hola, excelente canal; casi todo me lo vi :) Tengo la siguiente pregunta. A partir de un cumplimiento (Ejecutado/Meta) que cambia de acuerdo al tiempo, debo calcular un color que esta parametrizado en otra tabla. El cumplimiento lo tengo en una medida (measure). ¿Como envió este cumplimiento (medida calculada) a cruzar con otra tabla (colores) para saber cual me debo traer?
+Santiago Espitia Pinzon Hola Santiago, muchas gracias y me alegro que te gusten :) Podrías poner tu pregunta en la comunidad de Power Bi? Muchas gracias y buen fin de semana, /Ruth
Dear Rut thanks for videos , seeking your support to calculate MOC based on STK of Previous Month - [TOT FCT] current month+ [TOT Purch ] current month + [previous month closing STK] come from the same measure I need the result to be used in next month for same measure I have dimension separate date table your support is highly appreciatedThanks
Hi +AHMAD GAID, Could you please post this question in the Power BI Community? community.powerbi.com When you get an answer, the solution will be then indexed by google and others can also benefit from it. Thanks! /Ruth
Hi! I am facing a problem, Running Sales is not coming as expected, it is just copying the SalesAmt Column. Others are coming just fine. Can you say what maybe the possible reason? Thanks!
Hello Ruth, I was able to create a calculated measure of running total sales using this formula: CALCULATE([Total sales with sumx], FILTER(ALL('MPSsales2012-2020'[Invoice Date].[Date]),'MPSsales2012-2020'[Invoice Date].[Date]
Congratulations on the class! But I have a problem: I need to classify 15 thousand products in A, B and C, based on a base with 15 million lines, and the way you passed is not possible. Is there any other way?
Hi me again... so I built my report and everything worked awesome, however, I found my TOT_HELD Measure is not excluding my plants "Filter" TOT_HELD = SUM(NCM_Cost_of_Defects_UOM[Qty Held]) this measure shows all plants totals vs 'Filtered'... But the Measure H_CUMM is excluding plants correctly "Filter"... I notice my CUMM was lower (correct #) then then if you added the # in the TOT_HELD manually its higher. H_CUMM = CALCULATE([TOT_HELD],TOPN([H_RANK],ALL(NCM_Cost_of_Defects_UOM[Defect Type]),[TOT_HELD])) How do I make my first measure take into account for the filtered plants and show the correct #? Thank you!!
Hi can you give me a hint to calculate the Running total with duplicate dates. (example: when there are many orders per one day) Date Order Order Qty running Total 11/17/2020 A 5 5 11/17/2020 B 10 15 11/17/2020 C 4 19
Hi. First add a calculated column: Rank = rankx(tblorders,tblorders[Order],,1) Then use a measure: Running total = CALCULATE(sum(tblorders[Order Qty]),filter(all(tblorders),tblorders[Rank]
Hi thanks for video, have question on grouping.. what if we want to group these items based on % like Top 20% items into one group and remaining 80% into another bottom group, since if we have thousands of rows and grouping will good option.. how to do this, plz help
Hola Ruth. Tengo un problema con las sumas acumuladas y es que en lugar de fechas tengo un consecutivo. He probado la forma en que haces la suma acumulada probando con el Rankx pero lo que devuelve son "1" en todas las filas. Me puedes ayudar por favor....
@@CurbalEN Hi Ruth, so "earlier" function only works for calculated columns, it gives de current row in order to compare. But for measures, "Max" function works the same as "earlier"? It shoudnt give the highest date of all date showed in the table? Please could you go a little bit through this? Thnaks in advance, and BTW, which is the link to the PBI community? Best regards
Hi Daniel, Yes, MAX can be used instead of EARLIER depending on what you are trying to do. I will definitely do more videos on the topic in the future. The link to the Power BI community is community.powerbi.com /Ruth
+akash ragi Hi Akash, without any details, it is difficult to answer your question. My recommendation is to post your query in the power bi community following this guidelines: community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490 /Ruth
@@CurbalEN I love you, thanks to your videos I'm learning a lot about DAX, thank you very much, I'm Brazilian and I found your channel because of Karine Lago, thank you for your videos
![[ TEASER ] เงาะป่า - วงL.กฮ. | TMG RECORD](http://i.ytimg.com/vi/M4ObdFfcPww/mqdefault.jpg)
You always do a great job of not over complicating things. TY!
OMG... you saved my life... everyone has told me Pareto don't exist in PBI... you made it happen we use them all the time !!! Thank you once again soooo very much!!! 💖
❤️ pleasure to be of help!
/Ruth
Thanks you so much, you saved me for another day of work trying to figure out what to do :D , after 3 days of looking at so many tutorial, this is THE MOST effective and efficient.
Gracias, Thank You, Merci!! You saved my month! I've been looking for this solution for weeks with no success. Now is clear. I loved also the article from Matt. I just had to adapt the DAX formulas, since my report pages is already pre-filtered by a "main" page, so I have to use ALLSELECTED( to keep the right records.
This is the first comment I write on your videos, although I like many of them. In summary, great work Ruth, keep moving!
Thanks for sharing your solution and saying hi 👋
/Ruth
Great video! I really appreciate you going through the differences when using time and other ranking. And your use of TOPN is just brilliant. I didn't see that in any of the other posts and videos that I've found. Thank you!
You welcome Torben, glad you liked it :)
/Ruth
agreed ... Thanks :)
:D
/Ruth
Thanks for sharing the video, 5 month before I struggled a lot to solve this , had to read a lot of blogs on PowerBI community and finally got the solutions. this video will help a lot of people.
+Amit Shukla Thanks Amit! If you know about other Dax Patterns I should do a tutorial on, please let me know!
Have a great weekend :)
/Ruth
+Curbal, Sure... in case if I have any doubt and looking for solutions to the problem where and how should I reach you?
+Amit Shukla Contact me @ Curbal.com/contact and I will give you my contact details!
/Ruth
ok Ruth
Hi Ruth, awaiting your contact details
HI Curbal, I saw so many videos and blogs, but no use. But ur video gave me the solutions for my project. Superb Curbal. Thanks a Lot.. :)
Glad to hear that!! :)
/Rutj
Fabulous. Yet again an excellent explanation as to how to accomplish a complicated objective (cumulative totals).
+Cloud Hound Thanks Christopher and Happy Saturday!
/Ruth
Always delighted to watch & learn when videos are produced, so well.
+Cloud Hound oh! Thanks Christopher! A lot of effort and enthusiasm goes into producing them 😊!
/Ruth
Hey Ruth, it's already like with Pavlov reflex .. when I see Dax Friday it's the moment where I start my weekend :-) and actually this topic is again very interesting and cool explained 👍🏻🎉 have a great weekend and greeting !
+SmartBimson Hi SmartBimson! I didn't know what the Pavlov reflex was... until now! 😂
Oh Dear... think if I miss one Friday! 😱
Thanks for all your support and have a great weekend too!
You make my Fridays w your comments:)
/Ruth
after a week of tryinig to figure it out found this video and it really helped, I did a few tweeks acording to my business case but tis helped me a lot, muchas gracias
Todo un placer :)
Finally after watching various videos on this subject this formula worked for me! Thank you so much! :-)
Glad it worked for you :)
/ Ruth
Hi Ruth,
I used exactly the formula you included here for the cumulative by date, only my table and columns have different names. The underlying data is the same, and I don't get a running sum, it's the Total Tooling Sales measure duplicated. Here's my DAX:
Running Sales = CALCULATE([Total Tooling Sales],
FILTER(ALL(ToolingOrders[Date]),
ToolingOrders[Date]
Hi Ruth , great video. I just came up with that one where running totals is worked out without ranking and summing up sales without dates:
SUMX(
FILTER(
SUMMARIZE(ALLSELECTED(sales),sales[item],"TOTALSALES",[Sum Sales]),
[TOTALSALES]>=CALCULATE([Sum Sales],VALUES(sales[item]))),
[Sum Sales])
Here "Values" is essential inside calculate as it retrieves the initial filter context of the pivot , and get out of the summarized table filter context in order to compare the total sales of the summarized table and current sales of the pivot . I would appreciate your comment. Dave.
Awesome, thanks for sharing :)
/Ruth
@@CurbalEN I could not get his to work for me (posted on another TH-cam channel as well) but yours WORKED.. thank you!!!
Another great video Ruth. Thank you for sharing.
+Fábio Coatis Thanks Fabio, have a wonderful weekend!
/Ruth
I've learned so much from these videos, thank you so much for producing these. My question is what if i want to exclude the first 2 dates from the running total?
Hi Ruth. Another great video. DAX Fridays! are really awsome! Running Total is a really interesting topic and very useful. Moving Annual Total and Moving Average could be further interesting topics. Best regards.
+Victor Friesen Thanks Victor, it is now on my to-do list. Have a nice weekend!
/Ruth
i don't understand the cumulative when there are TIES. Its not truly doing a running total for each product, right? It groups all the ties together. Is that how it is supposed to work?
I forgot about ties when I did the video.
You need to untie them:
m.th-cam.com/video/kRtmb8ftyQc/w-d-xo.html&vl=en
/Ruth
Thank you very much. I've been using CALCULATE/DATESYTD in my running totals, but always got some bugs, specially when I use tables. Now the problem is all sorted out.
Hi Ruth, i wanted to create running totals for Current (2019) and Previous (2018) Years and show them in line chart with Short Month name.
Cumulative Incident 2018 =
CALCULATE([2018], Filter(ALLSELECTED(CalendarTable), CalendarTable[Date]
Awesome video, thanks! The main question is though: why bother with Running Total if you can use YTD (or MTD) ?
Hi Ruth and Curbal community. This is a great video that accomplishes the result with very few steps (I've seen others that make the calculation more cumbersome).
I´m trying to complement the graph with a card visual that shows how many items represent < = 80% of sales, in the video for instance the value would be 4. I'm doing a calculation combining distinctcount with a filter (pareto % < = 0.8) but having trouble getting to the desired result on my report, any help will be welcomed and appreciated.
In the running total using rank, I see two values in the with 3rd rank and for item No. 6 it does not add the previous total. How do we overcome this?
can you please explain?
Hi. You can use a calculated column instead: Rank = Rankx(tblsales,tblsales[Item],,1)
Hello Mam - In which video you have clear the concept of Filter in your running total. Could you please share that link where in you spoke about 30 minutes.
I love your videos. Dax Friday is great! I wonder how to calculate a cumulative sum of demand until it meets/exceeds inventory then it stops cumulative. It’s a challenge for me but maybe I am overthinking it
Excellent! Thank you.
Glad it was useful Robert :)
/Ruth
Pls do a video on Pareto chart
Requirement: we have 2300 customers whose whose sales Loss/Profit vary from -2500000 to 4500000 USD in a FY in a company.
I want to show bottom most customers contributes to the business by using Pareto Chart. Pls explain.
Hi Ruth,
Thank you for your videos. I am constantly referring in order to deliver quality dashboards at work!
I notice a flaw in this logic: Referring tto 11:30 & 12:10. Row 3 & 4 are not actually getting added. Row 3 should be 41279 and row 4 should be 54914. Instead we have only one of those two values depending on your DAX formulae. The cumulative total doesn't seem to work in case of a tied rank.
Am I missing something ??!
Thanks for sharing videos. it's helping me a lot.
I have one scenario, please help me on that.
The scenario is, where we have to show cumulative for distinct count of IDs on year -Month. And it should display for last 12 months, however count should be taken from beginning of the date and it will filter the data based on slicer or filters.
Please let me know, if you need more details on it.
Thanks very much in advance.
Post your case in the Power BI community so when it is resolved others can benefit from it too. Google does not index TH-cam comments.
/Ruth
Hi, thank you so much for the hard work and nice tips you provide!
May I ask a question concerning the rank 3 item which is not included in the cumulative sum since both of items are ranked n°3 . We see that at the end of the video.
Great video!
Great video. Thanks
Please make a video on shorting the month in chronological order in slicer in power bi
Check if this helps:
m.th-cam.com/video/BnB4xUNisSA/w-d-xo.html
/Ruth
@@CurbalEN This is working ruth
Thanks a lot
Hi Ruth, posted a comment on Curbal FB page. Could not attach the image in here. Please do check and reply. Thanks, Anam
+anam470 Hi Anam, I take a look at it and let you know :)
/Ruth
Muchas gracias! excelente explicación!
+Norberto Vera Reatiga De nada Norberto :)
/Ruth
What if two items have same value, rank gives 1,1, instead of 1,2. SO how does it work in this case
Thank you for this great video and explanation!
Thanks to you for watching :)
/Ruth
Hi
I have a question what would be a syntax I will have to use if i need to have a % of increase in volume month on month. I cant add a new column since I use a live connect. I have a Column with the volume and another Column with Month. So I need a see what is the percentage of increase or decrease in volume from previous month.
Can you please post this in the power bi community? Make sure you post some sample data!
/Ruth
Great work as always. I think I already asked but TODAY() and MAX(Date) is the same right? But is this always true?
HI Daniel,
They are not the same. Today() will give you today's date while MAX(Date) will give you the last value on your date column. That is not always today's date :)
Hope I explained myself!
/Ruth
Hi Curbal, these formulas doesnt work on large datasets. Power Bi doesnt calculate at all. 300k lines ++
Hi Curbal - Big fan of your videos. Wanted to check if we can do opening balance and closing balance calculation for dataset having missing periods (months) which is very common when there are no stock movements? I tried using following calculations but these doesn't work when there are no stock movement for any period.
Opening Balance = OPENINGBALANCEMONTH([RunningTotal_CBQ] , Inventory[PERIOD])
--Closing Balance Formula as RunningTotal
RunningTotal_CBQ = CALCULATE(SUMX(Inventory , [Total_Qty]) ,FILTER(ALL(Inventory[PERIOD]) , Inventory[PERIOD]
Hi Ruth, thanks for the great videos with great explanations, is very helpful all the time. I have a bit of an issue here. I have a dataset where I have a cumulative count. have 3 categories as country, state and city (which are also in the report). where I need to get the latest value of the count (max) and also when no item is selected need to show the sum of the maximum values....How can this be achieved...Please need help.Thank you so much in advance
Hi Ruth,
I have one question about running total.
I have used All and all selected functions for getting running total. I received the same result.
Please explain me the difference between them.
Hi Ruth
Thanks for the informative video.
I feel if we cannot break the tie in the ranking, then the pareto chart will give the wrong line chart as the % will remain constant across categories having the same values. Since you are saying there is no way to break the tie in power BI, I feel it is better we don't create a pareto chart in powerBI
+Gopa Kumar Here is one way to break ties:
m.th-cam.com/video/kRtmb8ftyQc/w-d-xo.html
If you don't need a specific criteria for how you break the ties, it works!
/Ruth
Thank you.
But can we use that measure in TOPN to get the cumulative total over each and every category? when I tried replacing the normal ranking with the normal ranking + rand in TOPN, the cumulative total is not giving the correct values.
+Gopa Kumar Havent tried that, so can't really tell. I will give it a go as soon as I have the time !
/Ruth
No issues. Take your time. Just pointed it out. Thank you very much.
+Gopa Kumar Hi Gopa, thanks for your understanding. Time is something that I run out of all the time !
I can imagine it is the same for you ...
/Ruth
Hi please help me, how to calculate running total exclude current month
Hi Madam,
I am watching fantastic full of information packages.
But i stuck in one senerio can't find help.
Would you please assist me.
Suppose we have products A,B and C which are ordering in a month different days. I want running total of all product each month. Next month running start again means running total for each month not all 3 months.
I want solution in DAX.
I can calculate running total of 3 months but can't each month.
Thanks in advance
Hi Ruth, how about to have different ranks even for same "sales" ? Otherwise I think we would have a longer pareto because we are not making a distinction between items with same sales.
Sempre TOP! #powerbinareal ❤❤
I have been trying to download the example files for a few weeks now and it does not work?
Sorry to hear that, all download files have moved here:
curbal.com/donwload-center
/Ruth
Excellent!
Hello Rut, great videos.
I have a question how don't stay number repeats, in percent ?
Example
Item 4 = 71%
Item 6 = 71%
Sorry my english, i don't speak very well !
+Heliezer Garcia Hi Heliezer,
Could you please repeat the question? I speak also Spanish and Swedish if that helps!
/Ruth
+Heliezer Garcia Hi again,
Could be this what you are asking for?
m.th-cam.com/video/kRtmb8ftyQ/w-d-xo.html
/Ruth
Hi Mam.. I want to fileter here only 80% itmes. I dont want to show 20% and want to see upto 80% only, can u suggest me the measure for the same
Isnt the total of running sales wrong ?! or am i missing something here?!
Hey Ruth, i noticed that running sales other has a wrong total when you are calculating it for items. How to correct it or else give the idea if i completely want to remove that grand total. Because in other viz i also facing the same situation where i dont need grand total but still it appears.
To "remove" grand total in the visualisation, you can use field formatting (select the field - Font and background color: white - apply only to total) The grand total for the field will disappear.
Hola, excelente canal; casi todo me lo vi :) Tengo la siguiente pregunta.
A partir de un cumplimiento (Ejecutado/Meta) que cambia de acuerdo al tiempo, debo calcular un color que esta parametrizado en otra tabla. El cumplimiento lo tengo en una medida (measure). ¿Como envió este cumplimiento (medida calculada) a cruzar con otra tabla (colores) para saber cual me debo traer?
Lo e intentado de muchas maneras, como lograrlo desde PowerBi. Slds buen dia.
+Santiago Espitia Pinzon Hola Santiago, muchas gracias y me alegro que te gusten :)
Podrías poner tu pregunta en la comunidad de Power Bi?
Muchas gracias y buen fin de semana,
/Ruth
Why don't you show how the [Sum Sales] measure was calculated ?? 😔
Ruth hi, how can I get the actual total from the "running sales other measure"?. It shows 14005
Thanks!
Can you show how can I calculate %sales till a selected date wrt total sales made that month
How to get every month 15 Date & After 15 to Month-end Dates cummulative Sales
Ruth, One of my datasets only has month name and year. How can I get running total?
Post the question in the power bi community with some sample data :)
/Rutg
Dear Rut thanks for videos , seeking your support to calculate MOC based on STK of Previous Month - [TOT FCT] current month+ [TOT Purch ] current month + [previous month closing STK] come from the same measure I need the result to be used in next month for same measure I have dimension separate date table your support is highly appreciatedThanks
Hi +AHMAD GAID, Could you please post this question in the Power BI Community?
community.powerbi.com
When you get an answer, the solution will be then indexed by google and others can also benefit from it.
Thanks! /Ruth
Sure Ruth , appreciated , Regards Ahmad
Hi! I am facing a problem, Running Sales is not coming as expected, it is just copying the SalesAmt Column. Others are coming just fine. Can you say what maybe the possible reason? Thanks!
It is either your relationships or your DAX. Post in the power bi community and give as many details as possible to get support!
/Ruth
When I try this with a base with 9 thousand products it doesn't run.
Hello Ruth, I was able to create a calculated measure of running total sales using this formula: CALCULATE([Total sales with sumx], FILTER(ALL('MPSsales2012-2020'[Invoice Date].[Date]),'MPSsales2012-2020'[Invoice Date].[Date]
I owe you a coffee! Nice job as always!
Let me know when you are Sweden ;)
/Ruth
Congratulations on the class!
But I have a problem: I need to classify 15 thousand products in A, B and C, based on a base with 15 million lines, and the way you passed is not possible.
Is there any other way?
Do it in the source! Too much data.
/Ruth
But the source will not be dynamic as I filter by the date ):
Hi me again... so I built my report and everything worked awesome, however, I found my TOT_HELD Measure is not excluding my plants "Filter"
TOT_HELD = SUM(NCM_Cost_of_Defects_UOM[Qty Held]) this measure shows all plants totals vs 'Filtered'...
But the Measure H_CUMM is excluding plants correctly "Filter"... I notice my CUMM was lower (correct #) then then if you added the # in the TOT_HELD manually its higher.
H_CUMM = CALCULATE([TOT_HELD],TOPN([H_RANK],ALL(NCM_Cost_of_Defects_UOM[Defect Type]),[TOT_HELD]))
How do I make my first measure take into account for the filtered plants and show the correct #? Thank you!!
Uhh, mmmm that is a question for the power Bi community. Make sure you share sample data and your model to get proper help!
/Ruth
@@CurbalEN Thank you Ruth....
Hi can you give me a hint to calculate the Running total with duplicate dates. (example: when there are many orders per one day)
Date Order Order Qty running Total
11/17/2020 A 5 5
11/17/2020 B 10 15
11/17/2020 C 4 19
Hi. First add a calculated column: Rank = rankx(tblorders,tblorders[Order],,1)
Then use a measure: Running total = CALCULATE(sum(tblorders[Order Qty]),filter(all(tblorders),tblorders[Rank]
@@geertvandenbroucke9223 thanks Geert
Hi thanks for video, have question on grouping..
what if we want to group these items based on % like Top 20% items into one group and remaining 80% into another bottom group, since if we have thousands of rows and grouping will good option..
how to do this, plz help
You will need to do that calculation first. Please contact the power bi community to get help and give them as many details as possible.
/Ruth
Hola Ruth.
Tengo un problema con las sumas acumuladas y es que en lugar de fechas tengo un consecutivo. He probado la forma en que haces la suma acumulada probando con el Rankx pero lo que devuelve son "1" en todas las filas. Me puedes ayudar por favor....
Hola Javier, podrías poner la pregunta en la comunidad de power bi? Da todos los detalles que puedas para recibir ayuda rápidamente.
Saludos!
/Ruth
@@CurbalEN Claro que si, me puedes indicar como hacerlo por favor.
Regístrate en community.powerbi.com y listo!
/Ruth
I tried to calculate cumulative totals by using earlier but it didn't work. I can't find my errors.
Did you use a calculated column?
/Ruth
@@CurbalEN Hi Ruth, so "earlier" function only works for calculated columns, it gives de current row in order to compare. But for measures, "Max" function works the same as "earlier"? It shoudnt give the highest date of all date showed in the table? Please could you go a little bit through this? Thnaks in advance, and BTW, which is the link to the PBI community? Best regards
Hi Daniel,
Yes, MAX can be used instead of EARLIER depending on what you are trying to do. I will definitely do more videos on the topic in the future.
The link to the Power BI community is community.powerbi.com
/Ruth
Ruth muchas gracias a donde te mando un cafe !!!!
sabes como puedo usar el Pareto % as slicer? =/
can i know how to calculate average of sales for every year?
+akash ragi Hi Akash, without any details, it is difficult to answer your question.
My recommendation is to post your query in the power bi community following this guidelines:
community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
/Ruth
why the Total % is 18%. it doesn't make sense to me
I did that video a while ago, could it be this the problem?
th-cam.com/video/ufHOOLdi_jk/w-d-xo.html&vl=en
/Ruth
Lo logre! wujuuu :D
Genial!! Me alegra mucho! Ya nos ensenaras tu informe en la comunidad!
/Ruth
Si! lo voy a compartir siguiendo tu consejo, gracias!
+José Rafael Escalante Genial!
Спс. Очень доходчиво 🙄
пожалуйста 😁
Я не поняла что ты сказал
я тоже
@@CurbalEN kkkkkkkkkkkkkkk
@@CurbalEN I love you, thanks to your videos I'm learning a lot about DAX, thank you very much, I'm Brazilian and I found your channel because of Karine Lago, thank you for your videos
Thank You, but I don't understand why we need ALL in the formula. There is already filter which makes a "subtable" for the sum (FILTER range of dates