Need help urgently for Dynamic DAX. I want to created two dynamic slicers shown in image

[ramesh_1991]

How to created both Slicers 1 & 2 which will slice the data in main table

[Anonymous]

Hi @ramesh_1991 ,

Did @vicky_ 's suggestions help with your scenario? if that is the case, you can consider Kudo or accept his suggestions to help others who faced similar requirements.

If that also doesn't help, please share more detailed information to help us clarify your scenario to test.

How to Get Your Question Answered Quickly 

Regards,

Xiaoxin Sheng

[ramesh_1991]

client_id	alcohol_abuse	blood_loos_anemia	cardiac_arrythmias	renal_failure
5131	0	0	0	0
6982	0	0	0	0
11387	0	0	0	0
11417	0	0	0	0
17250	0	0	0	0
18367	0	0	0	0
20813	0	0	1	0
21852	0	0	0	0
21855	0	0	0	0
22201	0	0	1	0
22656	0	0	0	0
23192	0	0	0	0
23255	0	0	0	0
23347	0	0	0	0
23476	0	0	0	0
24366	0	0	0	0
24645	0	0	0	0
24865	0	0	1	0

[vicky_ · Accepted solution]

To get the Score Slicer, I would recommend creating a disconnected table with all of the possible values in those columns - if you are 100% sure that there will only be a set number of values, you can pretty much hard code it. Something like:

Score Values = {0, 1, 2}

Or if you know a range, then consider GENERATESERIES().

You will then need to create a measure for each of your columns - i.e 

alcohol abuse = 
var toReturn = SUM(Table[alcohol abuse])
return IF(toReturn in VALUES('Score Values'[Value]), toReturn, BLANK())
// ... and repeat for the rest of the columns

you need the IF condition to hide a value if it hasn't been selected in the slicer. This is a bit tedious, but only needs to be done once.
For your Measure Name slicer - create a field parameter, and just use the measures that you've created above.

[aduguid]

Can you paste example data for the table?