I’m writing an expression for a slice and am trying to filter the survey table data to:
- just one row (any)
- from each group of [survey_number] rows
- where the [branch_A_asset_list] row is not blank.
This is as far as I’ve got… but it’s not doing the job…
[_RowNumber] = MAX( SELECT( survey[_RowNumber], AND( [survey_number] = [_THISROW].[survey_number], [lcs] = [_THISROW].[lcs], [select_cabinet_to_survey] = [_THISROW].[select_cabinet_to_survey], [select_asset_type] = [_THISROW].[select_asset_type], ISNOTBLANK([branch_A_asset_list]) )))
From this example I’m trying to end up with just three rows - one from each highlighted area?
Thanks in advance…