Forum Discussion
drill through based on calculation
can it be possible to drill through based on calculation or measure , example i created dax expression for customer count of private , public and business sector % and placed measure in textbox , if i click on circle for 47 % (for private sector customer count ) then it should filter another page which is map based on only private sector occupation
To make the drill work by the measure you need the drill_trhough measure on the visual or to use it as the filter.
The engine cannot filter other visuals by the measure without the context.
So in your case, you can add a bookmark that will be filtered by the desired category.
More information about bookmarks here :https://www.youtube.com/watch?v=O3jG4m99D14
https://www.youtube.com/watch?v=mLs1YuIkqls
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
1 Reply
To make the drill work by the measure you need the drill_trhough measure on the visual or to use it as the filter.
The engine cannot filter other visuals by the measure without the context.
So in your case, you can add a bookmark that will be filtered by the desired category.
More information about bookmarks here :https://www.youtube.com/watch?v=O3jG4m99D14
https://www.youtube.com/watch?v=mLs1YuIkqls
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.