3 Ways to use Calculation Groups You Need to Know
ฝัง
- เผยแพร่เมื่อ 5 มิ.ย. 2024
- Join my Power BI Design training here: my.datatraining.io/pages/powe...
In this video I show you 3 less known ways of using Calculation Groups in Power BI. Enjoy this video and subscribe to always stay updated on my favorite Power BI tricks :)
Download file here datatraining.io/powerbi-how-to
--------------------------------
📊 TRAININGS 📊
---------------------------------
Power BI Design 4 Weeks Transformation Program my.datatraining.io/pages/powe...
Power BI Essentials datatraining.io/powerbilearni...
Business User Training datatraining.io/powerbi-busin...
For Custom Trainings and Consulting email directly support@datatraining.io
---------------------------------
⏱️ TIMESTAMPS ⏱️
---------------------------------
00:00 Intro
01:06 Example 1
04:49 Example 2
10:47 Example 3
19:15 End
---------------------------------
😍 JOIN 😍
----------------------------------
Join bit.ly/4b453bi
Subscribe bit.ly/31MnQGO
Insta / howtopowerbi
LinkedIn / basdohmen
TikTok / how.to.power.bi
X / howtopowerbi
fb / howtopowerbi
Threads www.threads.net/@howtopowerbi
Newsletter datatraining.io/newsletter
---------------------------------
👇 CHECK THIS OUT! 👇
---------------------------------
💻 My gear amzn.to/47F21Yc
📚 Power BI books MUST READ! amzn.to/3tUfFcj
💡 General books I recommend amzn.to/48YNo33
🎶 Music for my videos www.epidemicsound.com/referra...
🚀 For growing on TH-cam: www.tubebuddy.com/bas
🏄 Stuff I use daily amzn.to/3HqfMQ2
* Above are affiliate links, which means at no additional cost to you, if you make a purchase using these links we will receive a small commission. It supports us and helps us to continue making more How to Power BI videos!
Thanks for being a part of this channel and all your support! 💪 🙏
#HowToPowerBI #PowerBI #DataTraining
#powerbidesktop #powerbitraining #powerbideveloper #DAX - วิทยาศาสตร์และเทคโนโลยี
Incredibly useful Bas ! You summarized in 20 minutes what it could takes us hours to learn. You're a genius man. Thanks for sharing all these precious info that help data analyst to build nice and powerful dashboards
I recently replaced my horoscope youtube channel time with your channel, very relaxed watching ^ ^
CTRL + SHIFT + L blew my mind, again living under a rock if that was known by many! Great video!
here you have an overview of the most useful ones: th-cam.com/users/shortsI5HSerFTSDI
Without fail, you seem to always post content about something I'm actively working on. Thank you!
This is the best video I have found for calculation groups! Thank you.
Glad it was helpful!
@@HowtoPowerBI Hi, in my model view there is no model and table section could you please explain why? BTW, the program is updated to the latest version
@@azizagamirzeyev1143 go to settings, preview options, turn on model explorer and calculation group authoring
This is excellent once again Bas! Forever referencing your videos when I introduce ways to increase efficiency within Power BI to my team.
Example 2 in particular is great. Using USERELATIONSHIP to activate different perspectives within the model is a really common use case. This will make handling those instances so much easier.
Daily sales doesn't apply to my reporting and analysis so time-intelligence applications of cg's has never been useful to me. Your demonstration of other uses is very useful and insightful. Thank you, you are always at the "next level" with your understanding and application of pbi.
Well done Bas. Easy to follow and great use cases!
As always, very helpful video. Thanks!
great video. thanks for sharing your cg wizardry.
happy new year!
Thanks so much for this gem! Very useful!
Amazing!🎉Thanks for sharing you knowledge👏👏👏
Hi Bas, I just want to say thank you to you and your channel. I mean obviously you also want to generate income with your tutorials, but your achievements are way beyond sth countable. I'm more from a business backround, but loved to work with Data and wanted to specialize in that field in my masters degree, which I then couldn't afford anymore due to the fact that my wife got pregnant (best thing on earth to me).
So I stuck in a Job I didn't really like with litte time left to educate and grow. In addition to that, the most Courses or even Tutorials are very long-winded and kind of boring. I'm so happy to have found your Channel. Your Tutorials are on point and your enthusiasm really is contagious.
Thanks to you I started to improve in Power BI which leads to an employment as a Junior BI Analyst. I know (especially when I compare my skillset with yours) that there is plenty of room to improve, but for now I'm very happy excited!
Best rgds from Hamburg (Germany). See you in the comment section, whenever I need support :D
great to hear I could contribute a bit to your journey! 😊 now you have both the job you want and a kid ! 😁
Thank you. I work on a P&L Statement with two calc groups + some conditional formatting. Quite slow in the PBI Service for end users. I suspect the CF causing too many queries.
has this been confirmed?
Great video, thank you for sharing
Awesome!!! Looking forward to your next video
Excellent as usual 👌, Thanks 😊 for sharing
Very Useful !!
I like your focus on different use cases other than just time intelligence when using calculation groups.
Thank you!
Calculation groups are perfect, but I miss one thing, and that is sorting measures in visuals when using calculation groups in the legend. Do you know some tricks here?
Have a great year! :)
Tabular editor; calculation item index ("ordinal" define the sorting order)
You can drag calculation items up or down in the model pane, this is the same from what I can tell as setting the ordinal in Tabular Editor
Edit : it's using the ellipsis on the calc item > move > up/down etc
You truly a master! Thank you for sharing this helpful piece of your knowledge. I’ve a question, can we make an org chart in power bi with the default visuals or any custom visuals. For example if I’ve a data feed of 40+ employees with 4 to 5 levels within different departments . Similar to the one that we can create a diagram on power point. I’ve been looking for this since few months. But didn’t find helpful info. Could you please help on this.
Great Video.
Just one question : I noticed that in example 1, selecting values from the aggression slicer caused a delay in loading, which could lead to performance issues.
Thanks Bas! Fantastic and cler!
Thanks
Great ways to use them Bas, Bas im watching that all the logos of your pane swticher remains statics, how can i achieve this please? is really a pain in the head, to expand them each time i open the same report or a new one...
Another nice video. Thank you, Bas!
How about RLS? I think calculation group might not work with RLS because you use USERELATIONSHIP, right?"
First of all, thanks for the content!! Great as always!
One question - if you want to see the SUM and the AVG of the sales next to each other in the same table, how can you do that using CG?
Just pick both boxes in slicer. Usually its with ctrl but you can uncheck this option in the slicer setting and now you can check multiple boxes without using ctrl.
12:55 I saw many people writing DAX when using VAR RETURN like you (the main function is also a VAR, in this example is CF). Could you explain why you used CF is like a variable and returned itself? Are there any benefits?
Hi Bas, may I ask why the function SWITCH in your DAX is not using TRUE(), is there any advanced feature for the SWITCH function?
In this document above you have two sources,
Can I've amazon rds for psql , redshift and crowd twist connect to my same report
How many data sources can I connect to my power bi report, do you have a video?
can they be used in scorecards (or some other visual component), and how?
Happy New Year!
For the dynamicity of the third example, could you not try to match allselected vs values of fields and make a switch to return a table for the x functions?
Could be a pain to be exhaustive, but that way you could maybe do Year, Quarter and Product Category (only 2^3 scenarios to anticipate)
Happy ny!! Switch cant return tables or?
@@HowtoPowerBI You’re right, but you can then return the switch with multiple maxx and minxx for the scenarios and the switch accepts var inside expressions.
Hopefully, it does not calculate each scenarios.
If we have to multiple selctions, what can be done. for example if we have to highlight AVG,MAX values for a single measure
Thank you for the excellent content! I'm curious about whether Calculation Groups can be integrated with SVG measures. I've attempted to construct a visual where the measure dynamically adjusts when I switch between different calculation items, but it's not working as anticipated.
Yes you can use it also for svg as well. Will try to make a members video on it
@@HowtoPowerBI I'm looking forward to it. I'm sure it will be incredibly valuable and helpful. Thank you Bas!
Happy New Year!
Happy new year! 😊🎉
Thank you for your content. I find that calculation groups with aggregations "break" dynamic headers that use selected values from field parameters. Do you possibly know how this can be avoided?
Not sure what you mean
Hi Bas,
How to deal with Sum(Divide(sum(a),Sum(b))) in the calculation group as a measure ,as explicit measures are not useful while using calculation group
Hello dear, thanks for sharing
thanks for watching! :D
Hi! Is using calculations groups the right solution if I want to create a profit and loss statement with current year, last year (both from same table) and budget (from another table) next to each other in a matrix ? On row level i would also like to show profit % etc.
I think this video will help you th-cam.com/video/J4317R5BvsA/w-d-xo.htmlsi=_GS3RRvyH8woM2Op .. you can build it like in the video and to create the budget column you basically just create the same "master" measure that pulls in the budget values ... you could build it with a calculation group as well (got also a video on that)
Great episode i am following since the first video love your contents
What app you use to record your videos
Thanks for watching since the beginning, appreciate it :) for recording i would use camtasia or obs
thanks for your answer really I love your content and I recommend for every one I know. I am Power Expert for 7 years and still learning from you. Thanks a lot
@@HowtoPowerBI
really love your content I am Power Expert for 7 years and I still learn from you, keep you going .
thanks really appreciate your effort @@HowtoPowerBI
Happy New Year Bas!
Happy new year !!!🎆🎈🎊
Legend👍
☺️ 🙏 thanks
*Our Mentor is on Fire*
i don't see all this options in Power BI. is this only for premium?
Thx first of all, I am learning to use c groups and in this video there is a lot to study.in the second example it is possible to have on the same visual all the relationship activated?
tbh i hate dax, its harder than calculated table in tableau to get the same output
Tableau is so much more simpler. DAX really makes thing morecomplicated.
Yeah it is difficult, but there is a good reason for it.
Tableau can't get complicated calculation done especially when multiple fact tables are in scope.
The sheer versatility of DAX makes it harder but once you understand it, you can never look at tableau in the same way IMHO.
The bummer of CG is outside a table or matrix you need to use a slicer to select the proper element.
I think you can also add the Calculation group column to the Filter Pane. Eg. On visual level so that you can preset a certain conditional formatting setting without the need for a slicer.
What's the price of your upcoming design course in USD?
2975 usd ( using current conversion rate eur / usd )
👍👍👍👍
😎👊
You are so handsome☺️
Great stuff to start the year
🚀🎇