Forum Discussion
can you filter using countrow filter measures
Hello
I really need advice and would appreciate anyone who can help
on the left hand is a table consisting of three measures i created using counrows and calculate
e..g
Hi Maz_0102
This is not working because measures can't give a filter context like columns.
This is also a reason that you can't use them as a slicer.
You should have the column Building Database [Technical Risk] in the visual that you want to use as a filter.
or maybe to use bookmarks with the functionality of switching between the visuals.
In your case, you can use 3 blank buttons up to the table which will switch between the same table filtered in different ways.More information about switching between visuals with bookmarks here :
https://www.youtube.com/watch?v=cFZtUzABOa8
*again in your case the buttons will be blank without text / fill color.
and you will stay with the same visual just change the filterI generated a small example you can see how it works here:
+
Pbix is attached
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
1 Reply
Hi Maz_0102
This is not working because measures can't give a filter context like columns.
This is also a reason that you can't use them as a slicer.
You should have the column Building Database [Technical Risk] in the visual that you want to use as a filter.
or maybe to use bookmarks with the functionality of switching between the visuals.
In your case, you can use 3 blank buttons up to the table which will switch between the same table filtered in different ways.More information about switching between visuals with bookmarks here :
https://www.youtube.com/watch?v=cFZtUzABOa8
*again in your case the buttons will be blank without text / fill color.
and you will stay with the same visual just change the filterI generated a small example you can see how it works here:
+
Pbix is attached
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly