No More DAX? Power BI’s NEW Feature Explained (File Included)

With Visual Calculations, you might not need DAX anymore in Power BI.
👩‍🏫 Learn more about my Power BI course: bit.ly/3zHT4SM
⬇️ Download the example file here and follow along: bit.ly/viscalc...
Ever felt overwhelmed by the complexity of DAX formulas in Power BI? Or maybe you’re just getting started, and the thought of mastering DAX feels like a huge challenge. What if I told you there’s a simpler way to handle all those calculations?
Say hello to Power BI's brand-new Visual Calculations. Visual Calculations simplify writing DAX measures enabling you to directly reference fields in your visuals. That means less hassle and more time to focus on what really matters. Let me show you how you can use Visual Calculations to create powerful reports in no time.
LEARN MORE
===========
📰 EXCEL NEWSLETTER - join 450K+ subscribers here: www.myonlinetr...
🎯 FOLLOW me on LinkedIn: / myndatreacy
💬 EXCEL QUESTIONS: Get help on our Excel Forum: www.myonlinetr...
#Excel #PowerBI #VisualCalculations

[@MyOnlineTrainingHub]

❓What’s the most challenging DAX formula you’ve worked with? Learn more about my Power BI course: bit.ly/3zHT4SM

[@throndjohnson]

Pareto chart. I've tried the add-in for pareto, but it isn't easy to customize it the way I want. My DAX looks like this: Cause Pareto % = VAR __CurrentCause = SELECTEDVALUE(QM15[Cause group text]) RETURN IF( NOT ISBLANK( __CurrentCause ), VAR __AllselectedCauses = ALLSELECTED( QM15[Cause group text] ) VAR __CauseTable = ADDCOLUMNS( __AllselectedCauses, "@Count", [QNs Count], "@Rank", RANKX( __AllselectedCauses, [QNs Count] ) + RANKX( __AllselectedCauses, QM15[Cause group text] )/1000000 ) VAR __CurrentCausePos = MAXX( FILTER( __CauseTable, QM15[Cause group text] = __CurrentCause ) , [@Rank] ) VAR __CumCauseCount = SUMX( FILTER( __CauseTable , [@Rank]

[@chrism9037]

Super awesome thanks Mynda! This will save a lot of time if one is not a DAX pro.

[@MyOnlineTrainingHub]

Glad you like it, Chris!

[@ExcelWithChris]

You just make things so easy to understand. Thanks from South Africa.

[@MyOnlineTrainingHub]

Thanks for your kind words, Chris!

[@guenzizabdelaziz5185]

Hi Mynda. Your KZbin Channel is among the Best. You put a lot of effort into presenting better Content with good Pedagogy. I really admire your Videos on Power Bi. Thank you and Good Luck.

[@MyOnlineTrainingHub]

Thanks for your kind words and support!

[@johnbainbridge1931]

Hi there Mynda and thank you for this important tutorial! Is this option of 'New calculation' Limited to certain editions of power bi? I only see 'new measure' and 'quick measure'. I have a surprisingly simple calculation to register that I cannot easily do, which is to do with summing several fields. When I select the fields I wish to aggregate (each field itself is an aggregate), only the last one is retained.

[@MyOnlineTrainingHub]

Hi John, you need to enable this feature as it's still in preview. Go to the Options and settings > preview features to turn it on.

[@johnbainbridge1931]

@@MyOnlineTrainingHub Found it thank you! It was called Visual calculation I think

[@thaerfaraj]

once i added calculated groups i lost that functionality that you describe with respects to right clicking and show value as. Any suggestions how to fix?

[@MyOnlineTrainingHub]

I didn't test that, but it's possible/probable that it's a limitation of visual calculations.

[@mahansor8295]

Many thanks , useful as always , one question please, why I can't see new calculation function on my menu bar , my BI version is Aug 2024 , thanks again.

[@MyOnlineTrainingHub]

You need to enable it in the Preview features via the Options.

[@anindadatta164]

I cannot see any visual calculations tab in my power BI desktop. In which version is it available?

[@MyOnlineTrainingHub]

You have to enable it as shown at the end of the video. It’s a preview feature.

[@bloom6874]

Thank you so Mynda for this video. I would like to go through your entire PowerBI course however, it seems like bitly link is not working. I am getting failed to open page message whenever I click on this link. Can you pls check the link and update it?

[@MyOnlineTrainingHub]

That's odd, the bit.ly link works for me. Here's the page link, hopefully that works, but let me know if not: www.myonlinetraininghub.com/power-bi-course

[@bloom6874]

@@MyOnlineTrainingHub The provided link I can access. Thanks a ton.

[@cbacca2999]

Does this feature start with the August 2024 update or Sept 2024? Your video description doesn't say. I see it is in as a Preview Feature starting in the Feb 2024 version and I didn't turn that on.

[@MyOnlineTrainingHub]

It's still in preview.

[@elvyrorie1432]

Did they change these so users can export to excel with them? When it was in preview this was not the case and so we continued to just use regular DAX measures.

[@MyOnlineTrainingHub]

They're still in preview, but I didn't test that, so not sure.

[@TheCnshn]

I have a bad news you guys who don't write DAX formulas. You need always DAX. Practice makes you better.

[@MyOnlineTrainingHub]

Practice does indeed make you better and more fun 😜

[@X4Xubi]

I have the latest version of Power BI but it does not have the "New Calculation" option. Any idea?

[@MyOnlineTrainingHub]

You have to enable it in the Options.

[@martinbubenheimer6289]

Useful video! Can I also add visual calculations in the report editor in the web browser?

[@MyOnlineTrainingHub]

Yes you can!

[@martinbubenheimer6289]

@@MyOnlineTrainingHub Thank you!

[@bhenriquealves]

There are other limitations in Visual Calculations. I am encountering the following error: ‘The query contains an aggregate of a Hidden Projection, which is not allowed.

[@MyOnlineTrainingHub]

I've not seen that error before. You can try looking through the Power BI community forums to see if others are encountering the same issue.

[@hitesh202]

Really thanks a lot ! Mynda .I was struggling literally with this DAX functions.

[@MyOnlineTrainingHub]

Glad you can make use of this new feature!

[@israelrescalvo]

Congratulations, excelent explanation!!!!. What is the complexity of this calculation? Does retrieve all the data from origin or Does use the data from the visual?

[@MyOnlineTrainingHub]

It uses the data from the visual.

[@hamishmaxa6509]

Can we use DAX to hide for example the quarter totals of the 3 month moving average which doesn't really make much sense?

[@MyOnlineTrainingHub]

You can write your own DAX measure to do this, yes.

[@vikrammohite8673]

When I fecting data from excel sheet , all values coming with summation symbol

[@MyOnlineTrainingHub]

That sounds odd. Although, you should be able to clear it up with Power Query before loading to the data model.

[@deenkiroshni-pf4ur]

i spent more than an hour to figure out why my home tab wasn't showing Visual Calculation, it would have been nice, if you could add that to your video how to get it to your ribbon tab

[@MyOnlineTrainingHub]

I show you how to get them towards the end of the video. File tab > Options & Settings > Options > Preview Features > Visual Calculations

[@tibibara]

Thanks for this useful tutorial!

[@MyOnlineTrainingHub]

Glad it was helpful!

[@syrophenikan]

FANTASTIC!!!! Great work (as always)!!

[@MyOnlineTrainingHub]

Thanks for watching!

[@jessemacdonough2458]

Thank you so much, Mynda! Like you, I suspect that when this feature comes out of preview, they'll have other options available in Visual Calculations.

[@MyOnlineTrainingHub]

Thanks for watching, Jesse!

[@tmb8807]

I find writing DAX pretty tedious (I basically only ever use it if some calculation absolutely requires dynamic context), so this is definitely going to be of use. Hope it's in GA soon. Cheers.

[@MyOnlineTrainingHub]

Great to hear you can make use of this new feature!

[@alkagupta2401]

Do you have courses in Udemy. If yes, with what name?

[@MyOnlineTrainingHub]

No. I have courses on my site here: www.myonlinetraininghub.com/courses

[@dutchdatadude]

Thanks for sharing, I hope you like our work. There is much more to come! I will have a surprise for you next month 😊

[@MyOnlineTrainingHub]

Can't wait, Jay! Congratulations on what you've achieved so far 👏

[@charithaperera4768]

Many Thanks

[@MyOnlineTrainingHub]

You are welcome 😊

[@dutchinfluencer]

It's an addition, it doesn't replace regular DAX at all.

[@regme4life191]

Thanks a ton Ma'am for this informative video.

[@MyOnlineTrainingHub]

My pleasure 😊

[@mahadevkanchu8951]

Simple superb explained

[@MyOnlineTrainingHub]

Thank you 🙂

[@BossLevelPro]

My watch later playlist just ended Ninja Mi Ninja and onto discussing DAX. We truly have our pick of content to indulge. 😅

[@MyOnlineTrainingHub]

😁

[@mohammedaltaf4877]

Thanks

[@MyOnlineTrainingHub]

Welcome 😊

[@podamaire]

this has been there in mstr since 15 years ago .... so what if they charged premium for innovation or features which are not available elsewhere!

[@sumitavamaji3294]

is it only with Microsoft 365???

[@MyOnlineTrainingHub]

Power BI is not part of 365, so it's for anyone with Power BI. You need to enable the feature as shown in the video.

[@samuelmundia320]

Hi .. kindly include in your list how to do integrated financial reporting (income statement, cash flow and balance sheet using power query and power bi...thanks for sharing with us .

[@MyOnlineTrainingHub]

The answer to that is, not easily. 😜 as a result, I don't have any plans to do videos on these topics as they're very complicated.

[@r.vinodjames3083]

super class for power bi

[@MyOnlineTrainingHub]

Thanks so much!

[@ubaidimran7102]

Why don't they provide a T-SQL wrapper for DAX.

[@MyOnlineTrainingHub]

Good question.

[@fernandozarate1725]

Excelente, muchas gracias!

[@MyOnlineTrainingHub]

Gracias!

[@mosesopondo5131]

Awesome!

[@MyOnlineTrainingHub]

Glad you like it!

[@edge5817]

this is awesomeeee

[@MyOnlineTrainingHub]

Glad you like it!

[@MyOnlineTrainingHub]

Glad you like it!

[@xeeshanahmad8757]

Amazing

[@MyOnlineTrainingHub]

Glad you like it!

[@charliearmour1628]

Dax was/is a nightmare. Far too complicated. Glad it's going.

[@b0159673]

😂 It's not going anywhere. This is just an option in certain situations.

[@dougmphilly]

preach

[@neilgore]

super

[@MyOnlineTrainingHub]

Thank you 😊

[@robertbox5399]

What is DAX?

[@MyOnlineTrainingHub]

DAX is the formula language used by Power Pivot aka the Data Model which is found in Excel and Power BI. It stands for Data Expression Analysis.

[@domenicoieracitano2138]

I think I saw this feature on tableau ages ago...

[@MyOnlineTrainingHub]

Probably 😉

[@tihomirhristov77]

💚💚💚

[@MyOnlineTrainingHub]

Glad you like this new feature 😊

[@ksspqf6016]

Yeeeeeees

[@MyOnlineTrainingHub]

😁 have fun with it!

[@juanpablorvvv]

Visual calculations is still DAX.

[@amneetbola6733]

So basically it does not replace DAX at all lol but I guess it's useful for some simple calculations to apply on the fly

[@sebastiandiao3004]

Came here to learn how I could avoid using DAX. Because I hate DAX. It's unnecessarily complicated. Why on earth isn't it closer to SQL syntax for the standard stuff? It's so annoying. Sad to see that this video doesn't provide a real alternative. 😢

[@firstname4337]

why don't they just make python the default language for Power BI -- it would make things so much more simple

[@MyOnlineTrainingHub]

For python users, sure, but not for most people 😁

[@PixelMotionHD]

Wait, did you explicitly said, that data manipulation, data engineering and everything what's happening under the hood does not matter?

[@MyOnlineTrainingHub]

Not exactly 😁

[@oscararmandocisnerosruvalc8503]

Well it is important for sure , but you can test the templates and see how they behave . Everything os moving to a functional environment

[@chriskeo392]

Dax ain't goin nowhere

[@mathijs9365]

Dax is too complicated

[@MyOnlineTrainingHub]

Not for long 😜

[@ashbeez1090]

DAX is a nightmare to learn

[@MyOnlineTrainingHub]

It can be challenging, yes!

[@imconfused1237]

“Bye-bye DAX” ? Err no, I don’t think so. This is a gimmick for lazy users who can’t be bothered to learn. But I don’t mind that as those people will never be a threat to me 😂

[@arnoldnowak962]

clickbait