Forum Discussion

colacan's avatar
colacan
Icon for Resolver II rankResolver II
5 years ago

Selecting rows with highest value within group form virtual Table

Hi, Curetnly I have ID (duplicated) column only (Group column does not matter) . Starting from this column I want to create a table as below   ID Group Rand_Num Max_Rand_ID 1 ...
wdx223_Daniel's avatar
wdx223_Daniel
Icon for Community Champion rankCommunity Champion
5 years ago

colacan 

Table_rand is a variance, when it was calculated, it is fixed, any function can change its value. so CALCULATE in your formula is invalid. it did not deploy any filter on Table_rand. MAXX alway works on the all rows of Table_rand.