Getting Started with Calculation Groups in Power BI
Vložit
- čas přidán 30. 07. 2024
- Calculation Groups in Power BI are like placeholder calculations that can be scaled to multiple measures. In this slightly long video I'll talk about how can you get started with Calculation Groups using Tabular Editor in Power BI.
===== ONLINE COURSES =====
✔️ Mastering DAX in Power BI -
goodly.co.in/learn-dax-powerbi/
✔️ Power Query Course-
goodly.co.in/learn-power-query/
✔️ Master Excel Step by Step-
goodly.co.in/learn-excel/
✔️ Business Intelligence Dashboards-
goodly.co.in/learn-excel-dash...
===== LINKS 🔗 =====
Blog 📰 - www.goodly.co.in/blog/
Corporate Training 👨🏫 - www.goodly.co.in/training/
Need help with a project?💻- www.goodly.co.in/consulting/
===== CONTACT 🌐 =====
Twitter - / chandeep2786
LinkedIn - / chandeepchhabra
Email - goodly.wordpress@gmail.com
===== CHAPTERS =====
0:00 Intro
0:45 Why and What of Calculation Groups
1:50 Calculation Groups Example
12:59 Calculation Group Precedence
17:24 Sideways Recursion in Calculation Groups
21:57 My Courses
===== WHO AM I? =====
A lot of people think that my name is Goodly, it's NOT ;)
My name is Chandeep. Goodly is my full time venture where I share what I learn about Excel and Power BI.
Please browse around, you'd find a ton of interesting videos that I have created :) Cheers!
- - - - -
Music By: "After The Fall"
Track Name: "Tears Of Gaia"
Published by: Chill Out Records
- Source: goo.gl/fh3rEJ
Official After The Fall CZcams Channel Below
czcams.com/channels/GQE.html...
License: Creative Commons Attribution-ShareAlike 4.0 International (CC BY-SA 4.0)
Full license here: creativecommons.org/licenses - Věda a technologie
Revisiting this great tutorial, Power BI now supporting Calc. Groups, but still Tabular Editor is the master.
You have explained the concepts extremely well. Thanks for sharing!
Glad you like it 😊
Thank you Chandeep, this was very informative and crystal clear
Tabular Editor is to me one of the most beautiful tools if you are working with PBI.. very good explained! Congrats!
Awesome Chandeep! Wonder if calculation groups will ever become a native feature. Thanks for demonstrating. Thumbs up!!
Thanks Chandeep! I've been racking my brain trying to figure out how to get more than one calculation item to show within a visual without adding an additional calculation group. The sideway incursion gave me an idea to create a "Switch" calculation item that refers to other items in the calculation group. It just works! Cheers.
SWITCH (
TRUE (),
ISSELECTEDMEASURE ( [Dynamic Statistical Measure] ),--Blank measure within calc group
CALCULATE (
SELECTEDMEASURE (),
'1_group_statistics'[Statistical Measure] = "Linear Regression - Dynamic Measure" --calculation item that refers to a calculation group with higher precedence
),
ISSELECTEDMEASURE ( [Dynamic Statistical Secondary Measure] ), --Blank measure within calc group
CALCULATE (
SELECTEDMEASURE (),
'1_group_statistics'[Statistical Measure] = "Linear Regression - Dynamic Secondary Measure" --calculation item that refers to a different calculation group with higher precedence
),
SELECTEDMEASURE ()
)
Extremely Helpful Chandeep. God bless .. Keep it up ...
Excellent video. Easy to follow explanation.
As always Chandeep, explanations crystal clear! thanks for sharing !
Glad you liked it!
Thank you for doing this video. It is very helpful. Looking forward to seeing more of your work. :)
Glad you like this! Sure, stay with goodly 💚
Amazing …. You explained it very well. Precedence concept was easy to understand. Thanks chandeep for this video ✌🏻
just discovered your channel, love your videos :) very well explained!
Glad you like them!
Great tutorial. Keep the good work
Great video Chandeep, thank you so much for sharing all your knowledge!!
Glad you like it!
Extremely useful tutorial. Super thanks!
Glad it was helpful!
Wonderful video.. there is a lot to learn here
Amazing thorough tutorial on Calculation Groups. Thanks
Glad you liked it!
Very lucid explanation with examples, Thanks a lot
Glad you liked it!
Excellent video on calculation groups. Is there a way to highlight one of the 'columns' in BOLD, say a Total or a special result?
This is a great video. It was a bit fast in a few areas but I quickly understood it once I watched the section a second time.
Glad it helped!
Hi. I like how straightforward your video is.
I just have a question, how do we now apply conditional formatting to values in a calculation group.
For example, I wanted to find the max value across all time periods ?
Excellent!
Again, double excelent. Thx
Really helpful.
Interesting, Thank you very much
Excellent presentation, thank you very much for your help
You are welcome!
Thx, excellent!
Really interesting...!!!!
Hi Chandeep,
Thanks for your channel, amazing content.
Is recursion sideway calculation added recently to tabular editor or it was there from beginning.
Hi Master 😉, Thanks for the interesting videos. One curiosity question, what is the best practice for the calendar table re time intel calculations, should it be till end of current year or till end of sales table?
A great video again..
Was waiting for.this as I'm a beginner 😁
Hello My friend, Thank you... Great Video
Hi,very nice explanation on calculation group.can you explain how to work with format the measure with decimal and with out decimal based units,thousands,millions selection in slicer. I want to use the format value in column chart
Thanks Chandeep, excellent video on calculation groups and its beauty, do tabular editor 2 and 3 has any technical i.e. coding challenges?
Thank you, this was very helpful! :)
Glad it was helpful Evaldash!
Finished watching
Thank for explaining.
Glad it was helpful!
Hi, Thanks for helping us to improve our knowledge in Power BI. Please help me if you know any solution to convert a calculated measure to calculated column.
Thanks!
Your total YTD for year 2012 at 23:08 should have been 30,783 instead of 30,784. Why that extra 1? Can't figure out, but a very nice and detailed explanation of calculation groups.
Awesome explanation👍
Thanks Gwendoline
Hi Sir, Thanks for sharing amazing feathers. I am trying to follow all your steps but for last year and YoY% I am getting the same values as this year. not sure what I a doing wrong. Would you be able to let me know how you have managed the relationships here. May be that's where I am making mistakes.
great video
Hi Chandeep
Thanks for the wonderful video as always
I have a question not related to Tabular, its related to dax
I want to calculate average of 1st quarter of last 5 years ( avg of 1st qtr of 2021, 1st qtr of 2020, 1st qtr of 2019, 1st qtr of 2018, 1st qtr of 2017 and similarly for month and day ). Can you help me crack the logic. Thanks in advance
Good Video thank you! 👍I Hope the Tabular Editor 2.0 will be available over a Long time. The latest Version is Not for free 😔
Hi Chandeep. Nice video. I have one question here, if l have 10 measures in the table and I want to apply the calculation group only to 5 measures in the table and remaining 5 should be as it is. Is this achievable using the selected measure function?
Wonderful video Chandeep
Thank You !
Hi Chandeep,
Awesome video!
I have some issues with Tabulor editor, that i really hope you can help me with.
Once i type in my table or Collum name in the expression, i don´t see any suggestions for my queries, and by typing the full expression, it can´t find any reference. Tables are visible in the model in Tabular editor 2.19.0
Thanks complex formulas explain simple way Can you help us source files for practice purpose
Thanks for your sharing. So, where I can get the PBI file?
Can we do the same thing using DAX Studio? or some kind of work around within PBI Desktop?
Great explanation! Thank you! Question, are there performance differences between using measures versus sideways references within items. Using calculation items as your base measure greatly simplifies your model, but I'm finding much slower in performance. Is this true in general, or possibly something I'm doing wrong with calculation groups. . Thank you!
I can't say that with certainty. Try with and without calculation group.
Also check the performance of your base measure.
Perfect
Thanks 💚
Why format of columns disappear. For example, column "Units" has a number format before calculation groups. After the calculation group, the format is not working anymore. It means you can't use column Units for another visual object. Please let me know about this...thank you so much!
Great video. Any chance to get a copy of the pbi file?
Thanks
Wow, that’s all I can say I watched a few tabular editor videos and this one explains it best, thanks a mil, and does version 2 still worth using?
TE2 is still pretty good but DAX editing experience isn't good.
@@GoodlyChandeep thanks for the reply, so it’s advisable to upgrade to 3
@@keagankemp6275 Yes. It's totally worth it!
When come to Group calculation, there is one major drawback is the selectedmeasure(). So I drag Revenue, profit, or any measure, but as a user, how to show that the based measure is revenue, profit, expenses or any measures so that user can understand the visual is measuring what?
I have 4 pricing type 12 sales total - Contract , Standard, buyin, Override. We want to see sales impact by price increase 1%, 1.5%, 2% and so on. but want to exclude buyin and override from calculating but they should return 12 sales total without any increase.
So my total should be Contract , standard with price increase and Buying, override without price increase. I used calculate columns to use "If" and "switch"function but the result is not dynamic when i change % increase.
Hey I want to know how we can do the calculation where I went to calculate row wise i.e in one row I need sum of few items and below that row I need percentage of those items divided by the total of those items
I tried to Implement the same but I'm not sure how to change the data type?
can they be used in scorecards (or some other visual component), and how?
supersticious as always
Thanks !
Hi..How can we add two group calculations
Ex: var lastmonth=........
var currmonth=.........
RETURN currmonth-lastmonth
The above is not working for me.....
Thanks
I dont get the intelligence opcion when typing the name of my calculated group. Does anyone know why? Without it I cannot reference the calculation item.
I have a query which is not solver by any body even Microsoft community। I think you can do that।।if yes i will share the details
HOW TO CREATE DIM DATE AND CREATE NEW TABLE
is calculation group can be worked in power BI?
Not yet
Aitäh!
Thanks for the tip! 😀
I think you said calculation group 1000 times and calculation about 700. Very distracting and slow in delivering concept. Meant as constructive criticism