Giampaolo Pitzalis on 25 Oct 2018 17:34:58
Calcuated columns at visual level
What about to add the possibility of creating calculated columns directly in each visual properties pane?
In certain cases, measures have high calculation costs and for all of other measures that depends on these we need to multiply the time to have the data out. In these cases, it could be useful to have the possibilty to create calculated column at visual level that, behind the scene, will be calculated by using the ADDCOLUMNS DAX function.
Example:
I have these 3 measure:
[Current] =
[Previous] = Calculate Current with SAMEPERIODLASTYEAR
[Previous %] = (Current - Previous)/(Previous)
If i use these measure in a table behind the scene PBI generates a DAX statement like this:
SUMMARIZECOLUMNS (
,"Current",[current]
,"Previous",[previous]
,"Previous %",[previous %]
)
Supposing Current takes 2,5 seconds to be calculated the final query should takes at least 7,5 seconds.
Instead, If i had the possibility to create column at visual level, PBI could generate a DAX statement like this:
ADDCOLUMNS(
SUMMARIZECOLUMNS (
,"Current",[current]
,"Previous",[previous]
)
,"Previous %",DIVIDE([current]-[previous],[previous])
)
that take 5 seconds to return the data.