Getting started with Visual Calcs in Power BI

It's been a long time coming but Visual Calculations within Power BI are here!!! Jay joins us to get us started on using Visual Calcs within our reports.
Share your thoughts on visual calculations (preview)
aka.ms/visual-calculations-fe...
Using visual calculations (preview)
learn.microsoft.com/power-bi/...
Jeroen (Jay) ter Heerdt
/ jaypowerbi
/ jeroenterheerdt
www.dutchdatadude.com/
📢 Become a member: guyinacu.be/membership
*******************
Want to take your Power BI skills to the next level? We have training courses available to help you with your journey.
🎓 Guy in a Cube courses: guyinacu.be/courses
*******************
LET'S CONNECT!
*******************
-- / guyinacube
-- / awsaxton
-- / patrickdba
-- / guyinacube
-- / guyinacube
-- guyinacube.com
**Gear**
🛠 Check out my Tools page - guyinacube.com/tools/
#PowerBI #VisualCalcs #GuyInACube

[@workstuff5253]

Making full DAX easier to debug would be a great addition to the product.

[@hi55us2]

Great video, can't wait for the support to come to more visuals

[@GuyInACube]

Awesome! What is the visual you like this to work with and how would you use it?

[@hi55us2]

@@GuyInACube definitely would love to use it on the line and stacked column chart, to have a line graph of a cumulative total and a bar chart of the yearly totals. Already do this with regular Dax measures, but visual calcs would be easier for new projects.

[@dutchdatadude]

@@hi55us2 support for the combo charts are coming!

[@mishymoo34]

As a minimal DAX person, I really like Visual Calcs. It's the best thing developed for on visual to date.

[@dutchdatadude]

Awesome, glad you like it!

[@alfredlear4141]

Microsoft just keeps getting progressively better with all their office apps. A great new tool for a great bit of software ❤

[@xyclos]

These are fantastic news!!!

[@olbu]

It seems that it could be calculated on top of the result of a dax query. What is the reason that on-premise SSAS isn't supported?

[@dutchdatadude]

That is correct. Not yet, at least.

[@Evaldas65]

How would the PREVIOUS function react if a year filter is applied? Say if I looked at 2021, 2022 and 2023 sales, and filtered 2022. In the 2023 column, would 2021, or 2022 be considered as PREVIOUS, if I filtered "Not 2022" in the visual?

[@dutchdatadude]

That would be 2021, since 2022 is then not on the visual.

[@noahhadro8213]

When you do versus previous and you are subtracting two measures. What is the engine doing? Is it evaluating that measure two times? Once for the original column and once in the verse previous measure? Would love for visual calc’s to be an optimization as well where the measure is only evaluated one time. I have a 100M fact table so optimization is key and I thought this could be a better way to calculate year over year. When having to show in a table current year, prior year, and year over year.

[@dutchdatadude]

it's not re-evaluating the calculation two times, it's only evaluated once against the source.

[@ExcelWithChris]

Please please help. Power Query. Somewhere I saw you can get a result in a step, then export that result to another query, come back to this query and ref the step before "exporting" and carry on with the current query.

[@huyhoangnguyen7465]

Using Window Function In This Feature to modify Context

[@dutchdatadude]

yes, you can do that.

[@user-cz2yu1li2q]

Hi It looks out of the context but I wanted to know if is it possible that can we 've Month on month %change of count even if we just have one month data and next month data is yet to get updated ?

[@dutchdatadude]

I am not sure I understand what you mean. Can you explain?

[@user-cz2yu1li2q]

@@dutchdatadude Hi I 've two month data and now I want month on month % change , while I need that it must show me change in a table view visual without any blank row dax

[@SachinWarrier-nn2bt]

I have matrix. In that first column is product. And the rest of the columns are Week1, Week2, Week3 upto week 52. Values in these columns are price of products in each week. I need to apply 2 seperate slicer of same thing. That is slicer values are week1, week2...week52. If I select week 3 from first slicer then matrix should show values on week3 only. And then I select week 10 from second slicer. Then matrix should show both week 3 and week 10 values only. Is there any way to do this.?

[@blaatfanaat]

You know the behaviour when a Power BI table's totals do not match the sum of the displayed values? When a counted item belongs to multiple row values, if you know what I mean. Do visual calculations offer a way around this? Showing the simple "dumb" sum of the displayed values? How?

[@dutchdatadude]

Not as simple as I want it to be, but yes, using isatlevel and collapse you can do that.