topic Re: Need help urgently for Dynamic DAX. I want to created two dynamic slicers shown in image in DAX Commands and Tips

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

ramesh_1991 — Thu, 13 Jun 2024 05:05:48 GMT

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

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

aduguid — Thu, 13 Jun 2024 05:27:22 GMT

Can you paste example data for the table?

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

vicky_ — Thu, 13 Jun 2024 06:37:38 GMT

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.

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

ramesh_1991 — Thu, 13 Jun 2024 18:40:33 GMT

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

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

Anonymous — Mon, 17 Jun 2024 05:28:24 GMT

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