multiple dynamic measurments including time slicers

asked 2022-12-05T19:00:31.953+00:00
Tischer, Johannes 1 Reputation point

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!

SQL Server Analysis Services
SQL Server Analysis Services
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.
992 questions
Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,333 questions
{count} votes

1 answer

Sort by: Most helpful
  1. answered 2022-12-07T11:05:52.623+00:00
    Alexei Stoyanovsky 3,321 Reputation points

    Unpivot the table so that your attribute names are values in a column and not column headers