The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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_all =
VAR SelectedColumns = CONCATENATEX(Parameter, Parameter[Parameter Fields], ", ")
VAR ExpresionDAX =
"SUMX(ADDCOLUMNS(SUMMARIZE(Table1, " & SelectedColumns & "), ""This"", [Vol_impact]" & "), [This])"
RETURN
ExpresionDAX
@fonsogijon , I doubt that in power bi as of now(Dynamic table based on selection).
You have to write a switch and combination
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
Hi, I am having the same issue :S did you find the way to solve it?
No, I just defined the lowest level possible that is also the default one and then it aggregates up depending on the selection