combining slicer-measure selection function in tabular editor

[Anonymous]

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

[PaulDBrown · Accepted solution]

@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]

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

[Anonymous]

also found this for more explaination 

https://www.sqlbi.com/articles/using-calculation-groups-to-selectively-replace-measures-in-dax-expre...

[Anonymous]

here's the most direct solution...

https://youtu.be/XCugcQ-_Zfk