Drill down in created measure, how to?

[ShaunH]

Hi there
I want to use a measure to count the number of times certain words appear in a column and based on that, be able to drill down and look at those records in a new sheet when double clicking on the value.
I am able to create explicit measures in the data model, but am not able to drill down into the values shown in the pivot table, as the values are filtered in the measures. I have tried implicit measures too without much success.

I also use slicers to filter further as I have YTD data and need to select which month I would like to see the data for, or at times the day or select a user or devision.
I have tried a couple ways and get the same results from all the measures.
Measure1:=CALCULATE(COUNT(Table[Color]),FILTER(ALL(Table[Color]),Table[Color] = "Red" || Table[Color] = "Green"))
Measure2:=CALCULATE(COUNTA(Table[Color]),FILTER(ALL(Table[Color]),Table[Color] = "Red" || Table[Color] = "Green"))
Measure3:=CALCULATE(COUNTROWS(Table),FILTER(Table,Table[Color] = "Red" || Table[Color] = "Green"))
Measure4:=CALCULATE(COUNT(Table[Color),FILTER(Table,Table[Color] = "Red" || Table[Color] = "Green"))
Measure5:=CALCULATE(COUNTA(Table[Color),FILTER(Table,Table[Color] = "Red" || Table[Color] = "Green"))

Another measure
Measure6:=CALCULATE(DISTINCTCOUNT(Table1[UserID]))
Measure7:=DISTINCTCOUNT(Table1[CustomerName])

The same value is shown for the calculations, no matter what derivatives I've tried.

My data model currently has over 500k lines and many columns. There are various measures for different things. The slicers affect all of them.
How does one get to drill down using filters in measures, that are also affected by slicers? I don't want to see the whole 1000 rows only, of the dataset, only the values in the measure.

This is highly annoying when you have data and some items need to be clustered together, and specific info is not view-able.

I have not found a solution on how to do this.
Anyone that can help me please?
Thank you

 

[ShaunH]

I realize I left some brackets out in the above, but it seems the drill down is not available in measures, only pivot tables with implicit measures where slicers or filters are applied directly to the whole pivot. I think this is a problem. I can't use slicers and pivot filters when calculating values.
My spreadsheet measures activities and the times these were performed. There are many types of activities and they are all recorded. Measures count these activities, or sometimes some activities are grouped by filters as a similar type of activity.
So when I double-click the measure, I want to see those activities that were defined for the person, not all their activities.

If anyone does have a solution, please, I would appreciate the help.
Thanks