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

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

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.

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.

Thank you! I always learn something new from your videos.

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.

The concept is so cleam and simple. It will definitely be usefull at a certain point. Thousand thanks Alberto ;)

Alberto, Thank you for time and tutorial. I always wait from your video.

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.

Could have used this exact solution just last week!! Definitely useful.

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!

very educational and a great way to get better at DAX

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 cool indeed and useful for salesman and customers

One more reason why multidimensional modelling is so important (the color dimension)!

Great.... Thks Alberto.

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👍🙂

Thank you for thaïs exercice : I will use it !

Always useful, without doubt

By all mean a great technique! I will use it very soon :)

No Doubt, It is very useful 👍

Very, Very useful. Thank You a Lot

Great example for learners!

Cool, will try

That's amazing ❤

Great video, as always. One question, what if I want to show every selected colors in column in the Matrix.

Useful, indeed

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

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.

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.

Extreme ❤️❤️🔥

Great!!

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?

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?

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

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

Alberto , it really cool

Consigo baixar essa versão do tabular editor

Could we have subtracted the Selected Colors total from the All Colors total in order to get the Other Colors?

good video! thanks, but I have a question. can this be done without tabular editor?

Please elaborate about Bill of Material BOM OF PRODUCT using power bi , DAX for procurement and production planning

🥷 skills !

How to count total number of rows of table using calculated group(calculated item)?

Is it possible to do this with Power Query?