Calculation groups for beginners | Power Bi update October 2023

Рет қаралды 9,825

8 ай бұрын

If you never worked with calculation groups before, here is an introduction video.
Join this channel membership to get access to all the recorded bites as they become available:
/ @curbalen
Here you can download all the pbix files: curbal.com/donwload-center
SUBSCRIBE to learn more about Power and Excel BI!
/ @curbalen
Our PLAYLISTS:
- Join our DAX Fridays! Series: goo.gl/FtUWUX
- Power BI dashboards for beginners: goo.gl/9YzyDP
- Power BI Tips & Tricks: goo.gl/H6kUbP
- Power Bi and Google Analytics: goo.gl/ZNsY8l
☼☼☼☼☼☼☼☼☼☼
POWER BI COURSES:
Want to learn Power BI? How about you take one of our courses? Here you can find the available courses:
curbal.com/courses-overview
☼☼☼☼☼☼☼☼☼☼
ABOUT CURBAL:
Website: www.curbal.com
Contact us: www.curbal.com/contact
QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here:
Linkedin ► goo.gl/3VW6Ky
Mastodon ► @ruthpozuelo@techhub.social
Twitter ► @curbalen
Facebook ► goo.gl/bME2sB
#CURBAL #SUBSCRIBE

Пікірлер: 32

@enocharthur4322 5 ай бұрын

I agree so much with your frustration with calculation groups. We need to have more control over what we want to show even though it's a calculation group

@mcnater 7 ай бұрын

100% on point for this...hopefully they'll update it. It's a low of slow steps forward with MS and PBI.

@infusionchurchmd Ай бұрын

I agree with you. I don't like that they force use of all items in the calculation group.

@NeBixAt 7 ай бұрын

I believe now you have to create a new calculation group for every measure separately. I mean one group for LY measures, another one for YTD, for example. It seems like a ton of work but if you have tons of measures, it still saves plenty of time and space not needing to calculate LY measures separately. Great input, Ruth!

@CurbalEN 7 ай бұрын

You are right, you can do that too. Specially now that is available natively in power bi. Might give it a try and see how messy it gets!

@bradj229 6 ай бұрын

This is the best calculation group video out there. I am not 100% sold on them yet either, but I'm glad I know how to set them up now. Thanks Ruth :)

@CurbalEN 6 ай бұрын

Being able to use the measures separate from the group would make all the difference in the world . Fingers crossed they will enable that!

@sohailansari9337 7 ай бұрын

Totally agree we need to use calculation group individually 😊

@rafaellopezguajardo3334 7 ай бұрын

Gracias ... Tienes razón, no siempre se requieren TODAS las medias en la visualización. Muy buen comentario Thanks... You're right, ALL stockings are not always required in the visualization. Very good

@adelawilliams2260 6 ай бұрын

Thank you for this video and your other videos, you have helped me immensely! You set up your videos in such a way that they are easy to follow and relate to my own challenges.

@CurbalEN 6 ай бұрын

Lovely to hear and enjoy the holidays :)

@samirvaghasiya2662 7 ай бұрын

Thanks 😊 ❤️

@Ken-tu7zh 7 ай бұрын

I feel the same way, Ruth 👍. Always I meet the situations where I need to develop further or make variations of existing measures when it comes to visualizations. Wish we can take those 'bundled measures' separately as you said.

@CurbalEN 7 ай бұрын

Hopefully soon!!

@gayatrilshinde1560 6 ай бұрын

This is really true because many times we have to manipulate many calculations and specially in finance report you have to calculate each row by different context it becomes really difficult to maintain the order and you just can not relly on calculation group and many times field parameters are also not greathelp..

@CurbalEN 6 ай бұрын

Hopefully they will do something about it!

@hiteshsharma618 6 ай бұрын

can we use Qty, lets say more than 10,000 (Time 5:12) with the above calculation group on the visual, Seems like it disables the calculated measure filter.

@JohnKpl 7 ай бұрын

To void error is it possible to use IF(SELECTEDMEASURE()BLANK(), ...)?

@sagarkulkarni2099 4 ай бұрын

Sum(Divide(a,b)) how to do this in the calculation groups

@jugarGV 7 ай бұрын

Interesting! another problem using Calculation Groups (not sure if is related with my DAX knowledge), is about conditional formatting, when the output element is related with a subtraction, addition or even divide, instead of the simple SELECTEDMEASURE() is not possible to add it.

@CurbalEN 7 ай бұрын

Didnt know, will check it out!

@benhalicki9749 7 ай бұрын

Thanks Ruth! I wish MS consult you before they implement new features :)

@CurbalEN 7 ай бұрын

Thanks ☺️

@davidcadman3562 7 ай бұрын

Thanks Ruth. I don't entirely understand the "use them individually" part. In the example couldn't you add the calc group to the table's visual filters section and then check only calc item PY there?

@CurbalEN 7 ай бұрын

I want to create them in group and use them individually like any other measure. I dont want them to be managed together. One simple thing can be the order. It will change depending on what you are doing.

@Nalaka-Wanniarachchi 7 ай бұрын

Great,BTW i didn't get using calculations groups individually part.

@CurbalEN 7 ай бұрын

So instead of using them all at once , you can use them individually

@paulrockliffe2378 7 ай бұрын

The trick to using them individually is to use filters. A single select slicer or the visual level filters, hidden or unhidden depending on whether you're aiming to give the user flexibility. It's not ideal, it does better in the visual build pane but it works really well.,