Forum Discussion
Evaluate row value to measure - simple example
Hi, Im trying to evaluate each column value agaisnt the measure but cant seem to figure out why it is struggling. A very simple 1 column table (Test); Number --------- 1 2 3 4 5 6 ...
- Usually, measures adapt according to the scope it is used for, so it will change to the standard deviation of the current row being evaluated and will always give an incorrect result. To overcome this you need to fix the calculation to estimate the value over all the values in the column. Use this one: STD = calculate(STDEV.P(Table1[Number]),ALL(Table1[Number])) Then do your check against this measure.
yelsherif
Resolver IV
Resolver IVUsually, measures adapt according to the scope it is used for, so it will change to the standard deviation of the current row being evaluated and will always give an incorrect result. To overcome this you need to fix the calculation to estimate the value over all the values in the column. Use this one: STD = calculate(STDEV.P(Table1[Number]),ALL(Table1[Number])) Then do your check against this measure.