include/Exclude column based on selectedvalues

[rakeshgali]

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

[amitchandak]

@rakeshgali , Please note that a calculated column can not take slicer value. You have to use a measure

Power BI Exclude selected Slicer value, Independent Table: https://youtu.be/lOEW-YUrAbE