REDUCE the # of measures with Calculation Groups In Power BI

Sometimes you end up with a LOT of measures that are related. You can reduce the number of measures with Calculation Groups in Power BI and clean up your field list!

*******************

Want to take your Power BI skills to the next level? We have training courses available to help you with your journey.

*******************
LET'S CONNECT!
*******************

***Gear***

#PowerBI #CalcGroups #GuyInACube

[zakirchotani]

Limitation or drawback of using calculation groups is that you may be unable to apply conditional formatting by measures. For example, in Patrick's example @ 6:44, what if you wanted to conditionally format a gradients YoY column that applies a gradient theme on most negative to positive amounts? Let me know if someone has a workaround it.

[sarahcook]

I teach a simple introduction class for an accounting product and I always recommend you guys as a resource for those looking for videos that are easy to follow. I learn new things from your channel as well. I love the short videos as it sparks ideas for things I can use to help me build dashboards for my own projects and gives me great direction for when someone asks about YoY, now I don't have to tell them to do as many DAX. So helpful!! AS ALWAYS.

[SolutionsAbroad]

This is so useful is SO MANY WAYS! Having these calculation groups pre-created for my future reports. Thanks Patrick!

[thestormoverkrynn]

I like it, but the lack of actual measures appearing in the calculation group will confuse users to no end. Would be great if they would just auto-generate named measures that could be dragged into visuals individually, using a slicer/filter seems a bit 'hacky'.

Nice clear video though, as ever!

[charliemather]

Patrick. Thanks. Good stuff! Good to note that implicit measures are no longer available if you add a calculation group. I know that explicit measures are best practice, but that can be a surprise to those unaware of that behavior.

[Ikarabaev]

I was able to reduce the number of measures from 178 to 61 thanks to calculation groups! This is so useful!

[Le-RACH]

WOW, JUST WOW.... EXACTLY WHAT IVE BEEN LOOKING FOR, MADE MY DAY! THANKS PATRICK!!

[phyberoptx]

I'm just starting with Calculation Groups, and I agree that they are a powerful tool in the toolbox. Things I'm missing with them: sorting, ability to rename a specific column in a group for one visual.

[guilhemdelorme]

This is great! I used to manually build slicer tables and construct switch measures to replicate that kind of behaviour, but this is much more scalable.

[neelkanthbk]

The tip on sorting the table by hiding the field was worth its weight in Gold!!! It solved a problem for which I was seeking solutions from weeks. Thanks a ton for sharing :)

[allthingspowerbiwithadebol]

This is definitely a game changer for me. Brilliant! Thanks for sharing.

[shirleysmith]

I have been saving this video for ages as I knew someday it will be useful and it just did!!! It saved me tons of headaches trying to put in place a requirement from the business. Thank you so much for sharing your knowledge with us!

[alfredsfutterkiste]

Finally I see these calculation groups that caused such a fuss in the community in action :)

[PradeepKumar-mhht]

This is really amazing, Thank you so much Patrick for introducing it.

[dangelo]

This is awesome idea! This can introduce completely different usage scenarios without any complexity to the DAX and keeping performance to the maximum.

[wnualplaud]

Hi Patrick, Thanks for always sharing the tips. I feel like I discover gold here when I watch videos from your channel.

[motichoorladdu]

WoW just I do this for a living daily. This just compressed my data model a whole lot. Did I just have a "work" orgasm or what!!! I maintain 100s of measures PTD, YTD, MTD, FY for each of the measures. Sometimes my measure tables look so big i mistake them for my fact tables. I need just one calculation group and I am done. Reconstituting my data model this weekend just to surprise myself.

[mangeshmehendale]

What do I do when I have a question on anything Power I head out here!!! You effing beauty - that cleared up so many things! Cheers

[mattjessop]

This is such a game changer. Currently we have to create these as separate measures, whereas we can just get users to know what group they need, rather than having to know which measures.

[AnalyticswithNags]

Good learning. You both are doing a great service by en lighting the people like us.