Noxter
Noxter

Reputation: 91

Store dynamic Measure values in Data Table dynamically

I want to store some measures in a data table column, but I want it to update automatically based on the current value of the measure.

These measures use 3 parameters which can be changed by the user via a slicer (one of the parameters is a weight value between 0 and 1) the other two parameters is an ID for the identification of the correct values (between 1 and 5, so ID can be 1,2, 3, 4 or 5).

Then, based on these parameters, a Weighted Sum is being calculated by the Measure.

I want this so we can do scenario analysis to see what would happen with which parameter setups.

I also want to do a line chart based on the measure values. For example for 7 Time periods I would have 7 measures, each would have their own 3 input parameters set up.

I want to store all 7 current measure values in a data table so I can visualize this table.

But when the parameters would be changed, I want the visual and the data table to update automatically.

Currently I managed to make the measures work dynamically with the parameters, but when I try to put it in a data table column, I am getting blank cells.

Please help me how to make this work.

For example, Measure one is like this:

Measure = ((CALCULATE(SUMX(DataTable, DataTable[Value]), FILTER(DataTable,DataTable[ID] = Parameter1[Parameter1 value]), DataTable[Time_category]="Category_0")) * Parameter_weight[Parameter_weight value]) + (CALCULATE(SUMX(DataTable, DataTable[Value]), FILTER(DataTable,DataTable[ID] = Parameter2[Parameter2 value]), DataTable[Time_category]="Category_0")) * (1-Parameter_weight[Parameter_weight value] )

The measure works, but I can't store it in the table.

Thanks.

Best regards.

Upvotes: 0

Views: 21

Answers (0)

Related Questions