Using VALUES while ignoring page filters ALLEXEPT?

[Anonymous]

Hi Everyone,  I have spent hours trying to find what would seem to be a simple thing.  

When the user clicks on the # AE Pat Population, I want to list the Patient Numbers in a seperate grid (this grid should ignore all page filters except for one).   The patient numbers are simply a list of related values or patient ID's.  

I Have this working, but cannot figure out how to set it up to ignore the filters applied to the page. 

#v AE Subject = CALCULATETABLE(SUMMARIZE('AE Table','AE Table'[BI_UNIQUE_PATIENT_ID]))

thanks!

[AlexisOlson · Accepted solution]

If you are using slicers for your page filtering, then you can disable interactions between the slicer(s) and the visual in question.

If your page filters are set in the filtering pane, while measures can reset filtering with versions of ALL, the visual itself will always be filtered by the filter pane, so dimensions won't show up if they've been filtered out.

The upshot is that you have to move filtering out of the filter pane if you don't actually want it to apply to the whole page.