【NEED HELP DAX】HOW TO APPLY "OR" FILTER ON MULTI-SELECT SLICERS USING DAX?(MORE THAN THREE SLICERS)

[Anonymous]

Hi, 
I want to filter a fact table using multiple slicers ("OR CONDITIONAL" AND MORE THAN THREE SLICERS ).
【e.g.】
If I choose Master-A's No.1 and Master-B's No.2 on the slicers, the table results should be all records that include Master-A's No.1 and Master-B's No.2. 

However, I am having a problem writing a masure for a facttable to use it for filtering the slicers.
It only works for one slicer. (IT'S NOT WORKING AS "OR" CONDITIONAL SLICER)
Here is the sample code that I wrote.
---------------------------------------------------

M_OR =

CALCULATE(SUMX('FACT_TABLE',[NUMBER]),

FILTER('FACT_TABLE',
RELATED('FACT_TABLE'[A]) = SELECTEDVALUE('master_A'[A]) ||
RELATED('FACT_TABLE'[B])= SELECTEDVALUE('master_B'[B]) ||
RELATED( 'FACT_TABLE'[C])= SELECTEDVALUE('master_C'[C])))

---------------------------------------------------

 

Could you help me find how to solve this problem?
Thank you.

[FreemanZ]

https://www.sqlbi.com/articles/using-or-conditions-between-slicers-in-dax/

[Anonymous]

Hi @FreemanZ 

Thank you for returning me so quckly.
I tryed the DAX below however, the slicers are not working. (It doesn't work at all.)

CALCULATE (

    [measure],

    UNION (

        CROSSJOIN ( VALUES ( T1[Column1] ), ALL ( T2[Column2] ) ),

        CROSSJOIN ( ALL ( T1[Column1] ), VALUES ( T2[Column2] ) )

    )

)

Could you help me find what is the issue here?

Thank you.

[Fowmy]

@Anonymous 

Please recheck your logic, when you apply a filter to a table, it is supposed to return one or more rows based on the conditions. in your case you try to apply OR here so any line that meets atleast one condition would return that row. check  if you are trying to get the rows that match all selected conditions using && instead of ||