Welcome to the QuickSight Community and thank you for asking your question here. In the calculated field definition, you can refer to the zone field in the dataset since you have 1-1 mapping between Organization and Zone. You may also want to look into dataset parameter. Here is an article with the details: Optimize queries using dataset parameters in Amazon QuickSight)
Related topics
| Topic | Replies | Views | Activity | |
|---|---|---|---|---|
| Parameter Values linked to Calculated Field | 2 | 123 | March 15, 2024 | |
| Values into Parameter | 5 | 1259 | March 14, 2024 | |
| Parameter for Calculated field | 4 | 519 | November 28, 2023 | |
| Passing value from calculated field to a parameter | 4 | 4479 | June 13, 2024 | |
| Using parameters in calculated fields | 7 | 86 | July 16, 2024 |