Forum Discussion
combining slicer-measure selection function in tabular editor
hi,
may i kindly ask if it's possible to combine the functions of slicer-measure selection (https://youtu.be/c0mPvzkf6i0) in tabular editor (https://youtu.be/vlnx7QUVYME) ?
tks: - nik
p.s.
for info, when i tried it, i get following error msg
Anonymous
It looks like you have values in the column which are not numerical. You can identify them by selecting the column in Power Query and changing the sort order. You will then need to replace them with whatever value which can be identified as a number (or as "null"/blank if pertinent)
4 Replies
Anonymous
It looks like you have values in the column which are not numerical. You can identify them by selecting the column in Power Query and changing the sort order. You will then need to replace them with whatever value which can be identified as a number (or as "null"/blank if pertinent)
tks, PaulDBrown.
i think i found the solution from following webpage
Generating a dynamic measure selector (tabulareditor.com)however, i still can't get it working (as per my note to their author in that webpage).
krgds, -nik
also found this for more explaination
https://www.sqlbi.com/articles/using-calculation-groups-to-selectively-replace-measures-in-dax-expressions/