For me, regardless of whether it is useful not to exercise itself, it is undoubtedly very, very useful to watch the reasoning and the way of thinking about the problem. It's like watching a painter develop his work. Thank you very much
This is indeed a useful method! Actually I was struggling with an issue last week in our financial reporting, which this video solved completely. Imagine having som projects which are of "reporting interest" currently, and all financial amounts falling outside of this selection of projects belonging to an "other" group. Your video was spot on!! Thanks, Alberto - Good explanation, as always :)
Alberto, you don't need to worry if this is useful, it is. It has made me think how to produce a variance analysis showing Actual Sales (or whatever), then the top three positive variances, the rest, the bottom three variances and ending at the budget sales. One of the most difficult things in any accountants presentation of results is to explain why things changed against plan. I am going to give this a go - I will happily share where I get to, but I would love to see your (inevitably) much more elegant solution. Thanks again for all you do on this channel, it is excellent always
Yes a very good solution. I am going to try to implement it on my project. Grazie Alberto per introdurci a nuove soluzioni per risolvere vecchi problemi.
Thank you so much for doing these. I find these videos to be very helpful. This particular one looks very powerful. This will be very useful on a report I have for calculating enrollment, FTE, and graduations from programs at our college. I have wanted to be able to show the comparison to other programs in the same department, programs in other departments, and all programs. I will have to give this a try.
Very inspiring , thank you for sharing this useful calculation. I would like to show a performance report for my client and I can compare one person' task with others easily by using this calculation.
Solution part creating other column, like in this case for color, I use for Excel PowerPivot. My model is simple one and now when see video I was on good way how to create something in Excel, which is calculation group in PBI. As always unplug is excellent learning case, and today is simple too. Thank you!
Great video. Might use this idea in implementing it in scenario where i want to see total and % of total for selected customers i.e. when I want to understand how much of the total sales revenue selected customers represent. Kind of a continuation of Pareto analysis
Nice, simple example to learn about measure groups. But for the specific use case the demand I face more frequently is to show one column for each selected color plus one column with the others value and maybe one with the total including others. And the selected colors are often selected by a Top N filter and others must be shown even if the others value is smaller than any of the selected Top N values. Is there a way in Power BI to do that without an additional artificial field? What least effort (an user friendly) solution would you recommend for that?
Hi Alberto, this is great videos as usual, and believe it or not i reference your videos in my brain how to use them like your video about treatas function for the balance sheet in power bi👍🙂
Can we dynamically group a product column based on the Sales Rank, so that in a stacked bar chart by region and products it just shows the first 4 ranked products separately and groups all other products as "Others" of that Region?
Thanks. Very useful. In my industry one example (just this week) would be to look at one particular brand vs all other brands so for me this was very timely
Hello Alberto, Thank you very much for posting this video and explaining in Simple terms. This is very useful for comparisons. APPRECIATE if you can add another video avoiding External Tools like Tabular Editor which requires License Purchase.
Tabular Editor 2 is free. However, now calculation groups can be created within Power BI Desktop in the model editor. learn.microsoft.com/power-bi/transform-model/calculation-groups
Alberto, and what about cross-filtering when you select a color from the table (not from the slicer)? Will it work as expected? Have not tried it yet... but maybe you already know. Thanks.
Hi Alberto, would it be possible to use something similar to this with your basket analysis daxpattern? For example with the “Both” measures in that one
Thanks Alberto - great video. Question - Wouldn't it be a tad-bit cleaner DAX to calculate Other Colors as difference of All colors and selected colors?
@@SQLBI That clarifies my confusion, thank you! BTW, these unplugged videos are great to develop a good way of thinking and solving DAX problems. Please keep them coming.🙂
Only with Tabular Editor or Visual Studio. Power BI Desktop does not have an internal calculation group editor, it will come, but it is not available yet.
It's great! May you please show the scenario of using selected and unselected values alone, not together. For example if i wanted to choose a black color but to see only other colors.
Been figuring out how to generate "extra rows" to capture the difference between the FX rate based on transaction date, and using the FX rate for month end for a Balance Sheet calculation. The "Gain/Loss due to FX" should be recorded in a ledger account, and I think this may be the solution
![[LIVE] : ONE ลุมพินี 96 | คู่เอก "คมอาวุธ vs พันฤทธิ์"](http://i.ytimg.com/vi/ofERaO0gOsE/mqdefault.jpg)
For me, regardless of whether it is useful not to exercise itself, it is undoubtedly very, very useful to watch the reasoning and the way of thinking about the problem.
It's like watching a painter develop his work.
Thank you very much
This is solving a business reporting dilemma I was wrestling with. Thank you!
This is indeed a useful method! Actually I was struggling with an issue last week in our financial reporting, which this video solved completely. Imagine having som projects which are of "reporting interest" currently, and all financial amounts falling outside of this selection of projects belonging to an "other" group. Your video was spot on!!
Thanks, Alberto - Good explanation, as always :)
Alberto, you don't need to worry if this is useful, it is. It has made me think how to produce a variance analysis showing Actual Sales (or whatever), then the top three positive variances, the rest, the bottom three variances and ending at the budget sales. One of the most difficult things in any accountants presentation of results is to explain why things changed against plan. I am going to give this a go - I will happily share where I get to, but I would love to see your (inevitably) much more elegant solution. Thanks again for all you do on this channel, it is excellent always
Thank you! I always learn something new from your videos.
Not sure if I can use this but I always learn something new from your videos, thank you. I find more uses for calculation groups all the time.
Yes a very good solution. I am going to try to implement it on my project.
Grazie Alberto per introdurci a nuove soluzioni per risolvere vecchi problemi.
Alberto, Thank you for time and tutorial. I always wait from your video.
Thank you so much for doing these. I find these videos to be very helpful.
This particular one looks very powerful. This will be very useful on a report I have for calculating enrollment, FTE, and graduations from programs at our college. I have wanted to be able to show the comparison to other programs in the same department, programs in other departments, and all programs. I will have to give this a try.
The concept is so cleam and simple. It will definitely be usefull at a certain point. Thousand thanks Alberto ;)
Very inspiring , thank you for sharing this useful calculation. I would like to show a performance report for my client and I can compare one person' task with others easily by using this calculation.
Could have used this exact solution just last week!! Definitely useful.
Very useful Alberto. An eye opener.
Solution part creating other column, like in this case for color, I use for Excel PowerPivot. My model is simple one and now when see video I was on good way how to create something in Excel, which is calculation group in PBI. As always unplug is excellent learning case, and today is simple too. Thank you!
Nice way to explain and enjoy DAX. Thanks!
Awesome 👌 solution. It can be useful. If we want to see the contribution of selected ones in total or how much left out from the selected ones.
Great video. Might use this idea in implementing it in scenario where i want to see total and % of total for selected customers i.e. when I want to understand how much of the total sales revenue selected customers represent. Kind of a continuation of Pareto analysis
so easy and so useful.
I hope an updated version of PBI will support the calculation group in the GUI directly.
it's really missing today.
Nice, simple example to learn about measure groups. But for the specific use case the demand I face more frequently is to show one column for each selected color plus one column with the others value and maybe one with the total including others. And the selected colors are often selected by a Top N filter and others must be shown even if the others value is smaller than any of the selected Top N values. Is there a way in Power BI to do that without an additional artificial field? What least effort (an user friendly) solution would you recommend for that?
See this article+video: www.sqlbi.com/articles/filtering-the-top-products-alongside-the-other-products-in-power-bi/
Hi Alberto, this is great videos as usual, and believe it or not i reference your videos in my brain how to use them like your video about treatas function for the balance sheet in power bi👍🙂
One more reason why multidimensional modelling is so important (the color dimension)!
Can we dynamically group a product column based on the Sales Rank, so that in a stacked bar chart by region and products it just shows the first 4 ranked products separately and groups all other products as "Others" of that Region?
Thanks. Very useful. In my industry one example (just this week) would be to look at one particular brand vs all other brands so for me this was very timely
Great video, as always. One question, what if I want to show every selected colors in column in the Matrix.
Thank you for thaïs exercice : I will use it !
very educational and a great way to get better at DAX
Hello Alberto, Thank you very much for posting this video and explaining in Simple terms. This is very useful for comparisons. APPRECIATE if you can add another video avoiding External Tools like Tabular Editor which requires License Purchase.
Tabular Editor 2 is free. However, now calculation groups can be created within Power BI Desktop in the model editor.
learn.microsoft.com/power-bi/transform-model/calculation-groups
Very cool!!!
Great.... Thks Alberto.
Very cool indeed and useful for salesman and customers
Always useful, without doubt
Alberto, and what about cross-filtering when you select a color from the table (not from the slicer)? Will it work as expected? Have not tried it yet... but maybe you already know. Thanks.
Hi Alberto, would it be possible to use something similar to this with your basket analysis daxpattern? For example with the “Both” measures in that one
By all mean a great technique! I will use it very soon :)
Great example for learners!
Very, Very useful. Thank You a Lot
Consigo baixar essa versão do tabular editor
Thanks Alberto - great video. Question - Wouldn't it be a tad-bit cleaner DAX to calculate Other Colors as difference of All colors and selected colors?
It wouldn't work for non-additive measures (like distinct count), the calculation group should work on any measure.
@@SQLBI That clarifies my confusion, thank you! BTW, these unplugged videos are great to develop a good way of thinking and solving DAX problems. Please keep them coming.🙂
Could we have subtracted the Selected Colors total from the All Colors total in order to get the Other Colors?
Cool, will try
No Doubt, It is very useful 👍
good video! thanks, but I have a question. can this be done without tabular editor?
Only with Tabular Editor or Visual Studio. Power BI Desktop does not have an internal calculation group editor, it will come, but it is not available yet.
@@SQLBI alright, thanks.
It's great! May you please show the scenario of using selected and unselected values alone, not together. For example if i wanted to choose a black color but to see only other colors.
You can use the same technique - just implement the "others" calculation in a measure instead of a calculation group, it could be simpler to use.
Great!!
Been figuring out how to generate "extra rows" to capture the difference between the FX rate based on transaction date, and using the FX rate for month end for a Balance Sheet calculation. The "Gain/Loss due to FX" should be recorded in a ledger account, and I think this may be the solution
That's amazing ❤
How to count total number of rows of table using calculated group(calculated item)?
Is it possible to do this with Power Query?
Extreme ❤️❤️🔥
Useful, indeed
Please elaborate about Bill of Material BOM OF PRODUCT using power bi , DAX for procurement and production planning
Alberto , it really cool
🥷 skills !