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!
Download Sample: guyinacu.be/calcgroupssample
📢 Become a member: guyinacu.be/membership
*******************
Want to take your Power BI skills to the next level? We have training courses available to help you with your journey.
🎓 Guy in a Cube courses: guyinacu.be/courses
*******************
LET'S CONNECT!
*******************
-- / guyinacube
-- / awsaxton
-- / patrickdba
-- / guyinacube
-- / guyinacube
-- guyinacube.com
**Gear**
🛠 Check out my Tools page - guyinacube.com/tools/
#PowerBI #CalcGroups #GuyInACube
Пікірлер: 334
This is so useful is SO MANY WAYS! Having these calculation groups pre-created for my future reports. Thanks Patrick!
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.
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!
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.
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.
WOW, JUST WOW.... EXACTLY WHAT IVE BEEN LOOKING FOR, MADE MY DAY! THANKS PATRICK!!
@GuyInACube
3 жыл бұрын
Love it! Glad it made your day Ricardo! 👊
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!
Mind blowing. Thank you Patrick for explaining it beautifully!
Good learning. You both are doing a great service by en lighting the people like us.
@yuqinghuang5891
22 күн бұрын
Hey Nags, your video is pretty helpful too!
Great video, it's really made it clear what is required to set up calculation groups, I'll enjoy getting to grips with them over the next couple of projects.
Amazing!!!! Will solve many of the present ways of creating measures
I was able to reduce the number of measures from 178 to 61 thanks to calculation groups! This is so useful!
Thanks for putting this together! Very helpful!
I wish there would be more videos explaining calculation groups, @Patrick. This is so good that I had to track back to this video after watching it a year ago!
This is great. Thanks for creating this video. Helps a lot!
This is awesome idea! This can introduce completely different usage scenarios without any complexity to the DAX and keeping performance to the maximum.
@GuyInACube
3 жыл бұрын
Indeed! It's a game changer 👊
Thanks a lot Patrick! Perfectly explained!!
Wow, this is awesome!!! thanks Patrick!!!
This is definitely a game changer for me. Brilliant! Thanks for sharing.
@GuyInACube
3 жыл бұрын
Awesome to hear! 👊
Awesome feature!! Thank you for that!
This is awesome! Thanks Patrick
This is pure gold! Thank you!!
This is amazing! Love your videos. Thanks for sharing!
@GuyInACube
3 жыл бұрын
Appreciate that! Thanks for watching👊
WOW! Really awesome! Thanks Patrick
This is so easy to follow. Now I can create better Power BI reports. Awesome! Thanks Patrick.
WOW! This is so powerful, love it!
BIG thumbs up! See alot potential in that concept! Thanks for explaining it in an easy understandable way!
@GuyInACube
3 жыл бұрын
Most welcome! Thanks for watching 👊
This is an awesome idea. Thanks, Patrick
Wow!! Great stuff!! So useful. Thanks a lot!
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.
Amazing. Thank you for this demo
@GuyInACube
3 жыл бұрын
Most welcome Najim! 👊
Wow, one of the best improvements to my meager power bi skills, I love this , thanks!
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 :)
This is amazing and we look forward to using!👍
This is really awesome! Thank you so much!
Hi Patrick, Thanks for always sharing the tips. I feel like I discover gold here when I watch videos from your channel.
Simply Amazing, this makes development so much faster.
@GuyInACube
3 жыл бұрын
It can definitely help 👊
This is so awesome. Thank you for a great tip.
Awesome, thank you so much for this
Awesome Patrick!!
Amazing video, thanks.
Simply awesome!
Pain relief. Thank you 😊
Well done Patrick.
Excellent issue! I created a bunch of measures to obtain several measures from two anothers that do the "Top N + Others" calculation with two different variables. There are like 30 formulas for each group and it is hard for others to read them. Now, I can write (again) the 30 formulas just once and, with selected measures i can manage between the two variables. Gonna try. Thanks.
Thank you it's amazing
as just about everyone else has said..... "WOW!". Thanks Patrick
@GuyInACube
3 жыл бұрын
Appreciate that Spencer! 👊
Excellent.. it’s of great help👍👍👍
Dude you just got yourself a huge fan! Thx for that!
@GuyInACube
3 жыл бұрын
WOW! Appreciate that a LOT! 👊
This is good. Thank you
I freaking love this!!! You've just shown me a great solution to what I was trying to implement in my reports!!
@njmd12
3 жыл бұрын
I'm quite new to PowerBi and have been fighting with my employer to get properly trained in this software, but what I've already learnt from following you guys is better than any training I had so far!
That's Great, thanks for the excellent content 🙌
This is just Great, nice job - Amazing!
Great explaination !
Finally I see these calculation groups that caused such a fuss in the community in action :)
@GuyInACube
3 жыл бұрын
Woot! Thanks for watching 👊
This is very useful in my organisation as i have a hell lot of measures needs to be created for all the time intelligence calculations.
Beautiful stuff
So awesome to be able to build this in PowerBI- just like you can in SSAS!
@GuyInACube
3 жыл бұрын
Yes! This has been a long awaited feature.
Patric, this is PBing awesome!!!
Really awesome on the caluation group
Very nice Thank you very much
Amazing!!! Thanks Dude!
@GuyInACube
3 жыл бұрын
Appreciate that Bruno! 👊
Awesome video!
Awesome info
This is amazing!
Nice work.
Great video, thanks Patrick. Is there any way to add conditional formatting to individual columns when using this approach? Thanks.
Amazing!
I was wondering this week how could I filter measures in a visualization. Now I have my answer :) ty so much
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.
Great new feature and you are awesome with the video
Very useful
PERFECT VIDEO
I had simulated calculation groups in ssas tabular 2016, and have been using it since then, as it didn't had sets concept. July release made it much easier. 👍 Guy in a cube on fore arm 👊
@chethankumar3655
3 жыл бұрын
Thank Patrick, just wow
Awesome Guys...!!
Awesome Patrick, it just exploit my mine🤘
What do I do when I have a question on anything Power BI?????? I head out here!!! You effing beauty - that cleared up so many things! Cheers
@GuyInACube
3 жыл бұрын
wow! Love to hear that! Glad it was helpful for you. 👊
great video! such an powerful step up in utility of measures. as you say... next step is to combine with dynamic axes.... let's see that video soon! :)
Great article ! I use calculation Group for a custommer report and he love this features. But the first drawbacks he reveal is that it can use slicer / filtre nor sort order columns. If somebody has any tip on how to enable sorting by calculation item, you Will make my day !!
Awesome 👍
I love the way you explain things, like we were dudes, pals, friends, that's really nice, haha cheers from Brazil
This is so amazing....
this is awesome!
@GuyInACube
3 жыл бұрын
Appreciate that Pedro! 👊
you just saved a lot of time for me.. I was supposed have 200+ metrics.. Also we can have these as builtin templates in powerbi in future probably...
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.
3 жыл бұрын
I have submitted this as an idea ideas.powerbi.com/ideas/idea/?ideaid=2bbc3ffd-78f2-ea11-bf21-0003ff52cdee.
@hiteshsharma618
6 ай бұрын
Is there a workaround it ??
Nice video!
I like this -- awesome!!
@GuyInACube
3 жыл бұрын
Great to hear! 👊
This looks like a very cool feature for ... Eases the job of the Dataset developer for sure. My mind however, goes to the End user who did not create the model but has to build reports from the model. Thinking that this saves time on the development of the model but maybe adds "complexity" for Report builders... Creates a need for good documentation on the model and "Calculation" groups... The report builder would not see the explicit measures for each item and then the variations, but rather one item and then need to filter for the specific measure calculation they need... In our "world" we have one or two people that build Shared Datasets and then many many people that build hundreds of reports off those models. I see a challenge in "training" new report developers. Suggestions on how to bake in some kind of clarity to a new report developers as to the "guts" of what is in the calculation group?
Millions Thanks
That's just wonderful, Patrick. Thank you. I see that you've changed everything to just using the "Time Intelligence" group. Can I assume it is safe for me to delete my existing measures, and change all my reference to the new field (in your case, "Name")?
Awesome !!!
Just lovely :) !
Thanks a lot for the video. Is there a way of using Tabular editor for calculation difference, sum or other aggregation of 2 or more different measures?
You just broke my mind, pretty amazing! Would've saved me so much time - I assume there's no way to vary the order in which they display and/or change the names in charts like we do with other measures? Maybe w/ additional columns...?
@JoelShafron
3 жыл бұрын
There is an "Ordinal" field that will allow you to change the order that they are shown.
This is dope, I don't see external tools tab though. Also, I feel as though volume weights should be calculated through this method as well that can be dynamic by selected measures and selected dates. I'm new to this, but I'm trying to pick it up!
Thank you very much for these videos, they have been a great help. I liked this video as it helped me remove over 60 measures however I am wondering how or if the calculation items can be used in other visuals. I have for example a line and stacked column chart where the line is (active employees YoY % Var) of a measure other than what is covered in the columns (New Hires and New Hires SPLY by month). Do I have to recreate my individual measures to use them in this fashion?
Finished watching
Great video. I love how the YTD functions can work. it will reduce the formulas by heaps. I will look at the other videos but am also looking to do something similar for budget and goal so in the same way that you have MTD, YTD etctetc for a selected measure. I also have budget and goal (which come from different tables from the filter criteria is the same. So kind of like Revenue = Calculate( Sum(ReportedValue), Apply some filter) Revenue Budget = Calculate(sum(BudgetValue, Apply same filter) Revenue Goal = Calculate (sum(GoalValue), apply same filter) It explodes x fold when you need to the time inteligence. I am going to see how calculation groups could handle this case. will let you know how I go but if you have any tips, would love to get feedback. Cheers
Thanks man this is awesome. What happens if I have multiple measures?
Great !