Create a dynamic Boolean column.

[Anonymous]

I have a Table - Table A

Slicers will be created for CV_score, BMI , Cond1 , Cond2

I want to create Columns CV, BMI_CAT, COND based on certain conditions as below.

CV=1 if CV_score>[Value input in a slicer created] else CV=0;

BMI_CAT=1 if BMI is contained in [Value input in a slicer created] else BMI_CAT=0;

COND=1 if (Cond1= [Value input in a slicer created] OR Cond2= [Value input in a slicer created]) else COND=0;

 i.e. I require columns whose definitions are dependent on the values the user inputs/selects on the slicers.

 How do I achieve this?

Table A

ID	CV_Score	BMI	Cond1	Cond2
1	1.067961	31.7	1	1
2	0.342015	21.5	0	0
3	1.406948	23.7	0	0
4	1.443875	38.9	0	0
5	1.09093	21.3	0	1
6	0.44023	19.7	0	1
7	1.179489	23.5	1	1
8	0.662609	39.9	0	0
9	1.219996	22.5	0	0
10	1.334029	30.7	0	1

[Anonymous]

Hi @Anonymous ,

I'm a little confused about your needs, Could you please explain them further? Which field is used to create the slicer? It would be good to provide a screenshot of the results you are expecting.

Thanks for your efforts & time in advance.

Best regards,
Community Support Team_Binbin Yu

[Anonymous]

Hi,

Thank you very much for responding. I have attached a screenshot of a sample i am expecting. To explain in further detail, the values in the slicers will help determine whether each ID belongs/Does not belong to each category. For example, if the slicer with CV_score is set to "between 1&2" ID's with score in that range will have CV=1 and the rest will have CV=0.