Reputation: 91
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