To filter or not to filter, that's the question

[Dennes]

Hi,

I have two tables, A and B, parent and child.

Table A is on a slicer, table B is on a Matrix.  Table B has a measure using table A on the expression, It's this:

NumFilter = IF(CONTAINS('Selector Table';[Number];'Super5'[Number]);1;0)

('Selector Table'=A; 'Super5' =B)

The problem is: When I select something on the slicer, table B is visually filtered according to the slicer and the measure is calculated according to the filtered slicer (filtered table A).

The measure is correct, that's what I want, but I don't want the direct visual filter, I have other plans for filtering.

Already tried two options: disable interactions on the visual and breaking the relationship. Both options apply for both situations, totally breaking the result.

I also tried VALUES inside the contains, no result. 

So: How to make the measure use the table A filtered according to the slicer without visually filtering table B?

Thank you!

[Greg_Deckler · Accepted solution]

Very difficult to say without sample data to play with, but perhaps disconnect your slicer table from your other table and use VALUES in a VAR.

[Greg_Deckler · Accepted solution]

Very difficult to say without sample data to play with, but perhaps disconnect your slicer table from your other table and use VALUES in a VAR.

[Dennes]

Hi, Greg,

Thank you for the suggestion. I tried, didn't work, no difference in the result.

Regards,

Dennes

[Dennes · Accepted solution]

Hi,

I found the problem.

On the first message, I said I had a measure, but it was not true: it was created as a calculated column, not measure. My mistake.

As soon as I converted it to a measure, it became able to get the filtered data from another table using the previous information, about creating a var inside the expression.

Regards,

Dennes