ISFILTERED results to multiple rows

[thescrimpton]

I am self studying Power BI/DAX and I am confused about ISFILTERED, specifically in the scenario below.

I have two physical tables, DimDate (#1 as slicer) and TestFact (#2 as table). The two tables relate via DateId (which is hidden).

Also I have 2 matrix visuals (#3 and #4). They are the same except that #4 has IsShipIdFiltered measure.

Now I am confused why does Matrix #4 is not interacting with the Date Slicer (as shown below) whereas Matrix #3 is correctly filtered. It is as if adding the measure ignores the date filter.

Someone help me please. I dont want to move along without fully understanding this. 

[v-chenwuz-msft · Accepted solution]

Hi @thescrimpton ,

If matrix #4 does not interact with Date Slicer, then the filter context of #4 will not be changed by Slicer. So the result of the measure will not change as the measure is calculated based on the context.

You can use the simple MAX() measure in the card to prove it.

Best Regards

Community Support Team _ chenwu zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[thescrimpton]

In addition, in Matrix 3 and 4, the numbers under customers are the shipmentid