drill through based on calculation

[powerbiexpert22]

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 

Private Count = DIVIDE(CALCULATE(DISTINCTCOUNT(Sheet1[CustomeID]),FILTER(All(Sheet1),

Sheet1[Occupation]="Private")),[Total customer])

[Ritaf1983 · Accepted solution]

Hi @powerbiexpert22 

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.