DEFINE MEASURE final_data[Incurred ILR] = DIVIDE(sum(final_data[total_incurred_claims]), sum(final_data[ctd_signed_premium])) MEASURE final_data[Ladder ULR] = DIVIDE(sum(final_data[ctd_forecast_ultimate_claims]), sum(final_data[ctd_forecast_ultimate_premium])) MEASURE final_data[test] = IF(final_data[Ladder ULR] < final_data[Incurred ILR],1,0) var filteredTable = FILTER(final_data, AND(final_data[test] =1,final_data[Ladder ULR] <> BLANK()))EVALUATE(SELECTCOLUMNS(filteredTable, "as_at_date", final_data[as_at_date_attrition], "dev_qtr", final_data[dev_qtr_attrition], "reserving group", final_data[reserving_group_attrition], "yoa", final_data[yoa_attrition], "Total Incurred claims", final_data[total_incurred_claims], "Signed Premium", final_data[ctd_signed_premium], "ILR", final_data[Incurred ILR], "Ladder Ultimate Claims", final_data[ctd_forecast_ultimate_claims], "Ladder Ultimate Premium", final_data[ctd_forecast_ultimate_premium], "Ladder ULR",final_data[Ladder ULR], "Ladder ULR < ILR",final_data[test]))
SELECTCOLUMNS IS A FUNCTION , it accepts the table name as the first argument, then you pass in the name of the column followed by comma followed by what that column should populate