Forum Discussion
combining slicer-measure selection function in tabular editor
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)
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/here's the most direct solution...
https://youtu.be/XCugcQ-_Zfk