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.
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!
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.
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👍🙂
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. 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
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.🙂
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
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.
This is solving a business reporting dilemma I was wrestling with. Thank you!
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! I always learn something new from your videos.
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!
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.
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.
Alberto, Thank you for time and tutorial. I always wait from your video.
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.
Very useful Alberto. An eye opener.
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
The concept is so cleam and simple. It will definitely be usefull at a certain point. Thousand thanks Alberto ;)
Nice way to explain and enjoy DAX. Thanks!
Could have used this exact solution just last week!! Definitely useful.
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.
very educational and a great way to get better at DAX
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/
Great.... Thks Alberto.
Very cool indeed and useful for salesman and customers
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)!
Great example for learners!
Great video, as always. One question, what if I want to show every selected colors in column in the Matrix.
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
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
No Doubt, It is very useful 👍
Very, Very useful. Thank You a Lot
Thank you for thaïs exercice : I will use it !
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.🙂
By all mean a great technique! I will use it very soon :)
Cool, will try
Great!!
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.
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
Consigo baixar essa versão do tabular editor
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.
Useful, indeed
Could we have subtracted the Selected Colors total from the All Colors total in order to get the Other Colors?
Extreme ❤️❤️🔥
That's amazing ❤
Alberto , it really cool
Please elaborate about Bill of Material BOM OF PRODUCT using power bi , DAX for procurement and production planning
How to count total number of rows of table using calculated group(calculated item)?
🥷 skills !
Is it possible to do this with Power Query?