2833
M

DAX calculations at visual level of reports

Marco Russo on 5/22/2020 3:48:20 PM
2833
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/
STATUS DETAILS
Planned
2024 Release Wave 2

Jeroen ter Heerdt (administrator) on 10/24/2022 6:50:51 PM

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

M

M

RE: DAX calculations at visual level of reports

Christian Key on 3/3/2023 10:38:04 AM

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

Thanks,

Chris

M

M

RE: DAX calculations at visual level of reports

John Yip on 3/2/2023 7:19:54 AM

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

M

M

RE: DAX calculations at visual level of reports

Sebastien RITLENG on 12/18/2022 8:43:11 PM

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

M

M

RE: DAX calculations at visual level of reports

Darren Fishell on 11/30/2022 6:52:21 PM

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.

M

M

RE: DAX calculations at visual level of reports

Jack Zheng on 10/7/2022 9:06:03 AM

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.

M

M

RE: DAX calculations at visual level of reports

Darren Fishell on 6/22/2022 2:51:37 PM

Tableau

M

M

RE: DAX calculations at visual level of reports

Christian Key on 4/26/2022 3:11:24 PM

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!

M

M

RE: DAX calculations at visual level of reports

Chandra Vadana Rajamohan on 1/18/2022 11:22:22 AM

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.




M

M

RE: DAX calculations at visual level of reports

C J on 7/21/2021 10:14:05 AM

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

M

M

RE: DAX calculations at visual level of reports

Andrey Reznik on 12/16/2020 7:17:40 AM

Calculations used in visuals would greatly improve performance of DQ mode as there wouldn't be need to go to database for each and every derived calculation.