This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(192, 99%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETJ%3C/text%3E%3C/svg%3E)
Hello,
i want to get the result of multiple measurements in the following way:
result1
result2
.
.
resultx
one single entry is the result of a measurement and depend on a time slicer performed by the Datetable:
result1 = CALCULATE(AVERAGEX('Table1',Attribute1]), ALLSELECTED('Datetable'[time]))
--> a simple moving average calculation based on the dates choosen in Datetable[time]
I cannot put the entries into a table, because of the calculation based on time (timeslicer) and will result in lost of the dynamic calculation.
Unfortunately, I need all results lined up in one column.
If you need more information, let me know.
Thank you in advance!
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
Hi,
Could you provide a simple sample table or data about the problem?
its more of a general question, but the data looks like this
Attribute1 / Attribute2 / Attribute3
1 / 1 / 1
2 / 2 / 2
3 / 3 / 3
4 / 4 / 4
and the time dataset is based on date/hours/min/sec
I have like 60 Attributes in one table and dont want to produce 60 measurements (with moving average) for only one visual.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(32, 95%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAS%3C/text%3E%3C/svg%3E)
Unpivot the table so that your attribute names are values in a column and not column headers
This is an example of my code and its all working fine. Originally, I wanted to include a timeslicer ( changes the values of VAR a between 2018 and 2022), but it doesnt work.
It is really interessting, because I tried multiple approaches and even if a in the timeslicer is equal to 2021 it will not work. If I directly give a the value 2021 (like in the picture) it is working.
Before that I tried something like var a = SELECTEDVALUES(Timeslicer). If I selected a value in the timeslicer (like 2018), my variable a = 2018. So it should be working, but it doesnt.
This code, once you remove the extraneous dot, will only work for a calculated table, not a measure. Calculated tables are calculated and persisted when the model is processed, so they cannot be influenced by any later selections in any filtering solutions, slicers included. So at the time the table was calculated, there were several values in Timeslicer and selectedvalue returned blank just as it should.
True, but is there a work around ? In order to get my visual I have to create a calculated table or at least a list of all the meaurements.
Why, this thread already contains two working ideas: coding 60 measures or unpivoting the table.
Both options won't work for me, but thank you for your time.
The support team of Power BI have to implement dynamic tables
Have a nice weekend!