Calculation groups for beginners | Power Bi update October 2023

Подписаться 135 тыс.

Просмотров 10 тыс.

50% 1

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

Опубликовано:

7 ноя 2023

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 32

@enocharthur4322 6 месяцев назад

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

@NeBixAt 8 месяцев назад

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 8 месяцев назад

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!

@infusionchurchmd 2 месяца назад

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

@bradj229 7 месяцев назад

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 7 месяцев назад

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

@mcnater 8 месяцев назад

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

@adelawilliams2260 7 месяцев назад

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 7 месяцев назад

Lovely to hear and enjoy the holidays :)

@Ken-tu7zh 8 месяцев назад

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 8 месяцев назад

Hopefully soon!!

@rafaellopezguajardo3334 8 месяцев назад

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

@sohailansari9337 8 месяцев назад

Totally agree we need to use calculation group individually 😊

@samirvaghasiya2662 8 месяцев назад

Thanks 😊 ❤️

@gayatrilshinde1560 7 месяцев назад

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 7 месяцев назад

Hopefully they will do something about it!

@JohnKpl 8 месяцев назад

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

@benhalicki9749 8 месяцев назад

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

@CurbalEN 8 месяцев назад

Thanks ☺️

@jugarGV 8 месяцев назад

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 8 месяцев назад

Didnt know, will check it out!

@davidcadman3562 8 месяцев назад

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 8 месяцев назад

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.

@sagarkulkarni2099 5 месяцев назад

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

@hiteshsharma618 7 месяцев назад

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.

@Nalaka-Wanniarachchi 8 месяцев назад

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

@CurbalEN 8 месяцев назад

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

@paulrockliffe2378 8 месяцев назад

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.,