Variable Calculation works in KPI but not in tables

[swetasingh]

Hi, 

I have a measure which works perfectly fine in a KPI and gives correct output on user input. 

However when i try to save the same output in table it gives me different results. Please see below example. 

Formula = Rangemax(1, RangeMin( $(v1) + $(v2) + $(v3), 100)) = KPI value works fine.

v1, v2, v3 and v4 are variables calculated on user input. 

Now I am saving the current selection in table , but when the use the same Formula it gives me different value than KPI. 

Any Idea why ?

[sunny_talwar]

May be try this

RangeMax(1, RangeMin(RangeSum($(v1), $(v2), $(v3)), 100))

[dplr-rn]

whats your expressions for the variables?
If it has set analysis; note that set analysis is calculated once per table not line by line

[swetasingh]

I have tried this gives me the same result. 

[swetasingh]

Yes my variables has set analysis. 

Is there any alternative way to store the value coming from KPI in a table so that the user can save it. 

I tried creating another table in the same sheet by dimension , where the formula works correctly. 

[sunny_talwar]

How exactly do you define v1, v2, v3?

[swetasingh]

v1 v2 and v3 are complex calculations coming from other variables getting calculated from user input values

[sunny_talwar]

okay... unless you are able to share a sample where this can be seen, it would be rather difficult to help.