Matt Allington on 04 Nov 2017 04:26:24
I see big value in creating a visual that can display the results of a DAX query. One way this could be deployed is a follows.
* Add the new visual to the report canvas
* Write a DAX query that returns a table (of course) and add this to the visual
* The visual would respect any cross filtering coming from the report just like any other visual.
This would give report writers very granular control to display records without having to use a table visual and a measure that triggers the display of the correct records.
Administrator on 30 Jul 2020 16:56:46
At the moment we don't have any plans to implement this. It sounds like it's mostly useful for learning/training? If there are other 'production' scenarios that you think it'd be useful, where a regular table/matrix wouldn't work, please let us know in the comments!
- Comments (23)
RE: DAX Query Language Visual
sample
RE: DAX Query Language Visual
test
RE: DAX Query Language Visual
Comment 1Comment 2Comment 3Comment 4
RE: DAX Query Language Visual
A simple use case for such a feature would be histograms and dynamic bucketing : how many sellers have had between 0-1000 customers , 1000-10000, … withing the current context.
This currently requires adding a dummy dimension to our model and write a dedicated measure that is more convoluted than required.
RE: DAX Query Language Visual
I totally agree with the last comment made on 2020 feb 5th, it could be great to make your own DAX script to avoid the issues when filtering the visual by a measure
RE: DAX Query Language Visual
One of the most important use cases of a dedicated DAX table visual is performance, especially when filter a table by a measure. I've done tests where the SUMMARIZECOLUMNS query that Power BI generates for a table takes 2-3x longer than an equivalently optimized version that I write using my own DAX. Same results, slower performance.
RE: DAX Query Language Visual
Even in a more general sense a concept in tabular similar to Views in sql would be great. A calculated table that includes current evaluation context/does not actually evaluate until it is called. If this could be another "table type" that a user/report developer could click and drag columns from this could be even more useful.
RE: DAX Query Language Visual
For sure would be good (to production environment) to create complex dax measures wich returns data table. (like Dax Studio does :) )
RE: DAX Query Language Visual
Very Very useful in debugging complex dax measures.
RE: DAX Query Language Visual
This would definitely help in building some complex queries (RANKX comes to mind) with multiple filter conditions - the truth is that wrapped DAX expressions can become very frustrating to dissect very quickly.