Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
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
Solved! Go to 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)
Proud to be a Super User!
Paul on Linkedin.
@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)
Proud to be a Super User!
Paul on Linkedin.
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-expre...
User | Count |
---|---|
85 | |
81 | |
64 | |
53 | |
46 |
User | Count |
---|---|
101 | |
49 | |
42 | |
39 | |
38 |