Forum Discussion

SuchCT's avatar
SuchCT
Helper II
4 years ago
Solved

Creating an inverse filter

Hello, I currently have one table with an "Order ID" that can have one or more "Item" inside,each item has an "Item Type" . I currently have a filter for "Item Type". I'm trying to get a second...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi SuchCT ,

    Please create a new table that has no relationship with the fact table and use this table as slicer.

     

    Table_re = DISTINCT('full table'[item type])

     

    Then create a measure as below and add it to visual filter.

     

    check = 
IF(SELECTEDVALUE('full table'[Order ID]) in CALCULATETABLE(VALUES('full table'[Order ID]),FILTER(ALL('full table'),'full table'[item type]=SELECTEDVALUE(Table_re[item type]))),1,0)

     

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

     

    Best Regards

    Community Support Team _ Polly

     

     

     

SuchCT's avatar
SuchCT
Helper II
4 years ago

Thanks for your answer! 
I think this would only show me the second table, where i see the items that don't contain A.

What I'd be missing here is the first table showing the items that do contain A selected with that same filter.



This is an image of the desired page. One filter for item type, and two visuals that change based on what was selected on that filter



Thanks once again

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi SuchCT ,

 

Create another new table and refer to the following steps.

Table = ALL('full table')

then manage the relationship.

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

 

Best Regards

Community Support Team _ Polly