Multiple filters on the same two columns

Thanks very much AZ38! 

I, implmented and it and got it working, but just so I understand what is happening. 

The new table contains the distinct domains in my source table as well as the distinct programs. 

The measure I am not 100% sure how it works. It calculates the distinct without blanks entry of the the program column, so far I am good. The ALLEXCEPT fuction ignores all the filters on the domains column and only apply the filter as it relates to programs. 

Thnaks, 

Laszlo--

Is there a JavaScript solution / override for that? 😀

I am using the PowerBI-JavaScript SDK,

the custom visual hierarchy slicer works just fine.

But when i  have try to use the Tuple filter in the JS SDK for (multi columns selection)  it turns out it is not really supported.

 slicer_Tuple_Filter = {

    $schema: "http://powerbi.com/product/schema#tuple",
    target:  [
  // same table different  columns selection  
{table: "Table A", column: "column A"}, 
{table: "Table A", column: "column B"} // same table different  columns selection

],

    filterType: 6, // can be int 6 or string 'Tuple'
    operator: "In",
  // value for selected columns  
    values: [

[ {value: "111"}, // value for column A
{value: "222"}// value for column B

]
]
};

Thank you! 🙂

here is the lick again:

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/40484047-fixing-power-bi-embedded-js-sdk-tuple-filter-allow