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)
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
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
RE: DAX calculations at visual level of reports
I think the new window function OFFSET() may do the tirck?
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
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.
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.
RE: DAX calculations at visual level of reports
Tableau
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!
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.
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