hi All,
we have a model with SALES TABLE with FISCAL QUARTER column and also period table with Fiscal quarter column. we are using fiscal quarter from period table as slicer to filter the dashboard. we created measures and its working fine but we want to create one include/Exclude column in Sales table which we can use as filter to include/Exclude values.
Please note that we were able to create measure but we want to create column. adding this measure in the filter like include/Exclude contains "Include" is working but kind of taking of lot of time and see performance is really bad.
Please suggest. Thank you in advance
Example : when i select 2023-Q1 in the fiscal quarter slicer from period table
i want my exclude/Include column values to be populate as shown below so that we can use this include/exclude column in filters
| FISCAL_QUARTER | SALES | INCLUDE/EXCLUDE |
| 2023-Q1 | 1000 | INCLUDE |
| 2023-Q2 | 2000 | EXCLUDE |
| 2023-Q3 | 3000 | EXCLUDE |
| 2023-Q4 | 4000 | EXCLUDE |
| 2024-Q1 | 3000 | EXCLUDE |
| 2024-Q2 | 4000 | EXCLUDE |
| 2024-Q3 | 1000 | EXCLUDE |
| 2024-Q4 | 5000 | EXCLUDE |
