I have created a nested gallery, and want each of the vertical galleries to be filtered by a different characteristic.
e.g. The gallery labeled 'receieved' [with value 1] to filter by received data, The gallery labeled 'investigate' will show investigated data.
The below code is working for one, but I need to extend it across the others
If(ThisItem.Value=1,Filter(TABLE_MASTER_DATABASE,'$ Phase'="Received"))
In my mind, this should look like this and work, but it doesn't.
If(ThisItem.Value=1,Filter(TABLE_MASTER_DATABASE,'$ Phase'="Received",
If(ThisItem.Value=2,Filter(TABLE_MASTER_DATABASE,'$ Phase'="Investigate",
If(ThisItem.Value=3,Filter(TABLE_MASTER_DATABASE,'$ Phase'="Respond"))))))
(Screenshot below - greyed out for sensitive info)