Alternate States - one matrix with 2 independant filters

[Anonymous]

Hi,

I am trying to create a matrix based the following assumptions:

1. it will show 3 columns: “Column A”, “Column B”, “deviation between A and B”
2. Data in Column A and Column B should be based on 2 separate filters that independent of each other
3. The purpose of it is to compare diferent scenarios (1,2,3,4,5,6) depanding on the selection in the filter.
4. Column "daviation between A and B" should be just a difference between two other columns. How can it be achieved in Power bi 

1. 

[v-shex-msft · Accepted solution]

Hi @Anonymous ,

AFAIK, current power bi not support 'OR' filter effect.
I'd like to suggest you to write a measure with specific filter conditions and return tag, then you can use this measure on 'visual level filter' to filter records.

Applying a measure filter in Power BI

Regards,

Xiaoxin Sheng