Dax for tooltip measure to ignore filters

[Neu_BI]

I am using a simple data model with a single 'table' that has a row for each individual [student_ID], the [unit_name] that they are studying, and their [study_status]. The table also has a field for the [year_of_study], but I am not using a separate date table. 

I have a stacked bar chart visual which uses a measure for distinctcount of [student_ID] as the value, with the [unit_name] on the y-axis, and the [study_staus] as the legend. The visual is filtered to show only one particular [year_of_study]

I would like to use a report-page tooltip to show a yearly trend for the count of [student_ID] for a particular [unit_name], but for all [years_of_study], and all [study_status] i.e. another stacked bar chart with [study status] as the legend that retains the filter for the [unit_name] that the tooltip hovers over, but ignores the filter for the [year_of_study].

Can anyone help me with a DAX measure that I could use on the report page tooltip to achieve this? Thanks!

[Neu_BI]

Hi @v-kalyj-msft

PREVIEW

What I meant was a tooltip with a stacked bar chat that has [year of study] on the axis and [study status] on the legend. It should retain the filter for the [unit name] that is hovered over in the primary visual, but ignore the filters on [year of study] and [study status].

I've actually found a solution that achieves my goal but it has involved me complicating the data model somewhat by using separate look up tables for [study status] and [year of study]. I'm sure that a more elegant and efficient solution is possible, however.

 The DAX for the tooltip measure that I used is:

ToolTip Measure =

CALCULATE( DISTINCTCOUNT( 'Table' [student_ID]),

ALLEXCEPT( Date_Table, Date_Table [Year]),

ALL( 'Study_Status' [Study Status])

)

Thanks for your time spent considering this.

[v-yanjiang-msft]

Hi @Neu_BI ,

According to your description, I create a sample.

But I'm not very clear about what "yearly trend for the count of [student_ID]" means, could you please explain more with the example.

I attach my sample below for reference.

Best Regards,
Community Support Team _ kalyj