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)

Using visual calculations (preview)

Jeroen (Jay) ter Heerdt


*******************

Want to take your Power BI skills to the next level? We have training courses available to help you with your journey.


*******************
LET'S CONNECT!
*******************


***Gear***

#PowerBI #VisualCalcs #GuyInACube

[workstuff]

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

[hius]

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

[mishymoo]

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

[alfredlear]

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

[noahhadro]

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.

[Evaldas]

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?

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

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

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

[huyhoangnguyen]

Using Window Function In This Feature to modify Context

[SachinWarrier-nnbt]

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

[czyuliq]

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 ?