Show table with different concatenated filters

[francesctesi]

Hi everyone. I apologise if the title of the question is wrong, but I was not sure how to describe the problem!

I've a table with two dimensions: Patient e Result

Initial Table

 I would like to be able to filter the two dimensions on the table to see only the following records:

• John with result A
• Mark with result B (not showing the first line)

This is the final result that i want:Final result

 Indeed, when using ordinary filters, the first row is always displayed in the results.

[Or · Accepted solution]

Create a concatenated field of Patient and Result, and filter on that field. This is usually best done in script - PATIENT & ' ' & RESULT as [Patient Result] - but you can also do it as a calculated dimension on the front end.

[francesctesi]

But if I have many dimensions and this concatenation I want to do in several cases, wouldn't the script be too complex to define single each case?

[marcus_sommer]

I think there won't be many possibilities to restrict views to such OR linking between independent fields. The suggested concatenation is probably the simplest way of providing it.

Normally should such a use-case rather be an exception for a special view and not the general method to select the wanted data. Within any BI tool is usually rather the opposite approach intended - and the pattern of similar data are evaluated.