Dynamic Summarize Calculation

[fonsogijon]

Hello,

I would like to create a measure where the totals is the sum of each row instead the calculation.

I managed to get that by using following formula:

Vol_impact =
SUMX(ADDCOLUMNS(SUMMARIZE(Table1, Table1[Col1], Table1[Col2]), "This", [Vol_impact]), [This])

However, there is not going to be always "Col1" or "Col2" as this are columns selected by user using the field parameter functionality.

I have thought to use something like this:

Vol_impact_all = 
VAR SelectedColumns = CONCATENATEX(Parameter, Parameter[Parameter Fields], ", ")
VAR ExpresionDAX = 
    "SUMX(ADDCOLUMNS(SUMMARIZE(Table1, " & SelectedColumns & "), ""This"", [Vol_impact]" & "), [This])"
RETURN
ExpresionDAX

Where SelectedColumns is correctly returning:
Table1[Col1], Table1[Col2], and adding more in case more are selected.

Which is dynamically working, but I have only the text. So I would like to "execute" this text. I thought with EVALUATE could be possible but it is not working.

Any idea?

Thanks in advance

[amitchandak]

@fonsogijon , I doubt that in power bi as of now(Dynamic table based on selection).

You have to write a switch and combination

[fonsogijon]

But I have around 30 columns available for users and they can select any number, so the combination is huge.
However, it looks like this variable is working fine, adding columns when users add columns in the slicer:

VAR SelectedColumns = CONCATENATEX(Parameter, Parameter[Parameter Fields], ", ")

And also the summarize formula returned is also dynamically changing base on the selection. The problem is that I have just the text, but seems to be fine, if only I could somehow evaluate that text...

Any way..Thank you!! @amitchandak 

[ecolores93]

Hi, I am having the same issue :S did you find the way to solve it?

[fonsogijon]

No, I just defined the lowest level possible that is also the default one and then it aggregates up depending on the selection