Getting started with Visual Calcs in Power BI

[@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!

[@workstuff5253]

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

[@alfredlear4141]

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

[@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.

[@xyclos]

These are fantastic news!!!

[@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.

[@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.

[@oguna2077]

@@dutchdatadude So it presents an incorrect analysis result?

[@dutchdatadude]

@@oguna2077 well since visual calculations work on what is on the visual, the previous would refer to whatever was previous on the visual.

[@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.

[@deeswift-z1h]

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?

[@deeswift-z1h]

@@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

[@jeremy8626-r6b]

Visual Calculations are great. It's almost as good as excel now.

[@jeremy8626-r6b]

Just need for them to figure out how to do code level edits and better git version control comparability.

[@AlainDelon-h9h]

🤣

[@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.

[@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.?

[@huyhoangnguyen7465]

Using Window Function In This Feature to modify Context

[@dutchdatadude]

yes, you can do that.

[@oguna2077]

OWWW NOOOO!!! a lot of new dax... i wanna cry right now!