Remove Outside Filters

[Kapcer]

Hi, 
I have a martix and a column chart.
The martix shows a person, their score (a measure) and about 40 other columns for that person. The matrix has an applied filter on visual for a date column. It is needed for all the measures to calculate correctly.
The chart is supposed to show how score changes over time for a person selected on a matrix. 

When selecting someone from the martix all I see on the chart is last month data (which is the filter on the martix). 
How do I filter the Calculate(Score, ...) statement so that it retains the context of a month from the column chart and the selected person from the martix without also carring over all the other filters. Appreciate any assistance which can be provided. 

Thanks,
Kacper

[JFAR49ER]

Hi Kapcer,

sorry that hasn't worked, could you provide the code for your measures? 
Does the column chart show all months when there is no selection on the matrix? 

thanks 

[JFAR49ER]

Hi,
I think the dax function that you would want to use is ALLEXCEPT, you can use this in the second part of a CALCULATE function to ignore all filters 'except' the specified column filter that you're interested in. 

In this case i think you would do something like CALCULATE(your expression, ALLEXCEPT(PersonTable, PersonID)) -- hopefully this basic example helps you. This would ignore the specific month column from the matrix and show all months to show the change over time but doesn't ignore the person you've selected from the matrix.

Find the microsoft document on the dax funciton ALLEXCEPT here: https://learn.microsoft.com/en-us/dax/allexcept-function-dax
This area is really useful for different dax functions.

Let me know if this helps 🙂

[Kapcer]

Hi, this doesn't work. The column chart still filters to last month when a person is selected.