Forum Discussion
Dynamic queries
jvandyck technically it is possible.
But how painful the development of that would be, depends on how many different indicators you have.
To the best of my knowledge, you can create Dax measures and viz for each indicator (slicer selection) and save them as bookmark. Depending on what users select, you can connect those bookmarks to each indicator (slicer selection) and which is how you can enable generating diffrent query as per each indicator selection.
But if you had the same set of columns regardless the indicators, where the only difference was the filtering, e.g
WHERE [fl_nt_npsn_adr_email_juist_patroon] = 1
OR [fl_nt_npsn_adr_email_ingevuld] = 1
you could have created Dax measures and a SWITCH stament to hook up that to the slicer selection without creating bookmarks.
Just to explain....there will be a number of indicators. The exact number I do not know upfront.
Each indicator will be based on a number of flags. The number of flags linked to an indicator can range from 1 to x. Right now all the indicators and flags are in one table as separate columns. If I would go for the bookmark solution, the number of rows would explode, and it would require work each time indicators and flags are added. The row explosion would be because I would have to unpivot all the flag/indicator columns