Skip to main content

Power BI

Completed

DAX calculations at visual level of reports

Vote (2881) Share
Marco Russo's profile image

Marco Russo on 22 May 2020 15:48:20

Provide a simple way to write formulas that work with the data displayed in a visual. For example, the running total of a measure in a table or in a chart according to the sort order of the visual should be something like this:

Running Total = ReportData[Sales] + PREVIOUS ( ReportData[Running Total] )

Where ReportData is the content of the current visual, Sales and Running Total are the names of the columns in the current visual. The user is not expected to know the model content, the calculation can be executed on top of any data currently being displayed.

More details about a proposal for visual calculations in DAX here:
https://www.sqlbi.com/articles/a-proposal-for-visual-calculations-in-dax/

Jeroen ter Heerdt (administrator) on 20 Feb 2024 22:23:33

Visual calculations are in preview since February 2024: https://powerbi.microsoft.com/en-us/blog/visual-calculations-preview/.

 

Update 10/17: This is now in our upcoming roadmap and we will share more details in the coming months.

March 2022 update: We are planning to support this, but we currently do not have a timeline

Comments (68)
Marco Russo's profile image Profile Picture

Scott Otoole on 10 Aug 2023 19:48:04

RE: DAX calculations at visual level of reports

Hello. Is this idea still on the roadmap for Power BI? Our organization and others could benefit greatly from this feature being implemented!Thanks

Marco Russo's profile image Profile Picture

Christian Key on 03 Mar 2023 10:38:04

RE: DAX calculations at visual level of reports

Hi. Can we have an update on the planned delivery of this new idea please?Thanks, Chris

Marco Russo's profile image Profile Picture

John Yip on 02 Mar 2023 07:19:54

RE: DAX calculations at visual level of reports

I think the new window function OFFSET() may do the tirck?

Marco Russo's profile image Profile Picture

Sebastien RITLENG on 18 Dec 2022 20:43:11

RE: DAX calculations at visual level of reports

This would be more than welcome. The amount of time spent as well as the number of workarounds required (sort order, totals, calculated groups...) to obtain a presentable result really curb the adoption.Especially since the rest of the app is making significant progress month in month out

Marco Russo's profile image Profile Picture

Darren Fishell on 30 Nov 2022 18:52:21

RE: DAX calculations at visual level of reports

Not encouraged by it taking two years for Gli Signori SQLBI to get the equivalent of SQL Window Functions or Tableau's Table Calculations on the development roadmap.

Marco Russo's profile image Profile Picture

Jack Zheng on 07 Oct 2022 09:06:03

RE: DAX calculations at visual level of reports

Formulas directly in the Table visual! Brilliant! This is also why people like Excel so much. Having this feature will make me move one more step closer to Power BI.

Marco Russo's profile image Profile Picture

Darren Fishell on 22 Jun 2022 14:51:37

RE: DAX calculations at visual level of reports

Tableau

Marco Russo's profile image Profile Picture

Christian Key on 26 Apr 2022 15:11:24

RE: DAX calculations at visual level of reports

This is very badly needed to allow us to migrate to Power BI embedded from legacy reporting solutions. Other competitors have this functionality. Fingers crossed that this is implemented in 2022!

Marco Russo's profile image Profile Picture

Chandra Vadana Rajamohan on 18 Jan 2022 11:22:22

RE: DAX calculations at visual level of reports

You can now achieve visual calculations using Inforiver for Microsoft Power BI!Excel-like formula engine and interface makes it extremely user friendly. Check out these videos for more details - calculated columns and rows and calculated measures.You can also leverage one-click calculations such as running totals, % contribution to parent/grand total, overall ranking, ranking within group etc. Inforiver also offers no-code budgeting, allocations, what-if simulations and forecasting capabilities and more.

Marco Russo's profile image Profile Picture

C J on 21 Jul 2021 10:14:05

RE: DAX calculations at visual level of reports

Yes ... in a matrix, it should be possible to just write a measure in column 3 = Column(2) / Column(1) .. Qlik has this