Passing filter value to tooltip from matrix that doesn't use the filter value

[Kimber]

The subject risk level columns (LA, Math, Sci, SS) are included in this matrix by 4 separate calculated measures applying a DAX filter on 'MyTable'[Subject]. I don't know if there's a better way to do it. The result is that there's no Subject filter for the matrix.

When a person hovers over the math column, I want the tooltip to show only the math courses a student is enrolled in. When hoving over Sci, only science courses, etc. I can't figure out how to make that happen. I welcome any suggestions! 

[Kimber · Accepted solution]

I was able to achieve what I needed to do by using my original matrix and creating multiple tooltips, one for each subject level. I set each tooltip to be associated with its corresponding measure, and then set Tooltips to "auto" on the matrix page.

[Kimber]

Specific to the student in their current grade. I don't care about their IEP, dual language status, etc in the student's previous grades. The main matrix shows students in their current grade. The tooltip shows all of the courses each student has taken in their current and previous grades.

[lbendlin]

Create a shadow copy of your data for the custom tooltip page. use TREATAS to project some of the drillthrough filters (like Math Risk level"  but not others (like Overall Score)

You may want to consider unpivoting your source data first.

[Kimber]

Thank you very much! If I understand you correctly, I should create a new table that contains the student schedule data, unpivoted. The structure of this table would be

Student ID	Subject	Course Title
1	Math	Algebra
1	Science	Biology
2	English	American Literature
2	Social Studies	European History

Is that correct? Can you give me an example of the measure I would write to pass Math to the tooltip when hovering over the math column in the matrix?

[lbendlin]

Please provide sample data that fully covers your issue.
Please show the expected outcome based on the sample data you provided.

[Kimber]

My data source 'RiskLevelData':

Student ID	Grade	Term	Subject	CourseTitle	LA Risk Level	Math Risk Level	Sci Risk Level	SS Risk Level
0732	10	S1	Sci	Biology 1	Off Track	Off Track		Off Track
0732	10	S2	Sci	Biology 2	Off Track	Off Track		Off Track
0732	9	S1	LA	Writing	Off Track	Off Track		Off Track
0732	10	S1	LA	American Literature	Off Track	Off Track		Off Track
0732	9	S1	SS	European History	Off Track	Off Track		Off Track
0732	9	S2	Math	Geometry	Off Track	Off Track		Off Track
0728	11	S1	Math	Algebra 1	Behind 0.5	Off Track	Behind 0.5	Behind 0.5
0728	11	S2	Math	Algebra 2	Behind 0.5	Off Track	Behind 0.5	Behind 0.5
0728	11	S1	LA	Writing	Behind 0.5	Off Track	Behind 0.5	Behind 0.5
0728	11	S1	Sci	Astronomy	Behind 0.5	Off Track	Behind 0.5	Behind 0.5

My report:

When hovering over LA Risk Level for Student 0732, I expect to see:
Student 0732

Grade 9  S1 Writing

Grade 10 S1 American Literature

[lbendlin]

Would this be an appropriate representation of your source data?

Then you can do a tooltip that works when hovering over the column totals.

[Kimber]

Thank you! That almost gets me to where I need to be. The problem is that I have a few more columns I need to include on the report, so that it looks like this: 

Using your file, I was only able to make the additional fields be repeated under each subject: 

Is there a different approach I should take? I'd attach the edited file, but I don't see a way to do that. I really appreciate your help!

[lbendlin]

Are these fields specific to the student, or the student and grade?

[Kimber]

They're specific to the student in their current grade. The matrix shows each student's current risk level in each subject and overall. The tooltip shows all the courses the student has taken. I don't care whether or not they were in ELL, IEP, Dual Lang or AVID in previous grades.

I found that if I put the student IEP, AVID, Overall Risk Score, etc as rows, I can get the layout I want. But then I lose my ability to conditionally format, which is essential to this report. It doesn't seem like it should be this hard. 😞