Forum Discussion

LWOLF's avatar
LWOLF
Regular Visitor
4 years ago
Solved

SELECTED VALUES IN TABLE

Hi all,   Could you please advice how to fix this issue? I need to exclude customers that bought at least one of the selected products. My current solution works if you select only one product, ho...
  • LWOLF's avatar
    LWOLF
    4 years ago

    thanks amitchandak . I actually managed to solve it after many hours of thinking! 😄 

     

    Products_exclusion = 
VAR _table = CALCULATETABLE(SUMMARIZE('main','main'[Customer ID]), FILTER(ALL('main'),'main'[Product] IN FILTERS('slicer disconnected'[Product])))
RETURN
IF(
    ISFILTERED(
        'slicer disconnected'[Product]),
IF(     
    MAX('Customer concat'[Customer ID]) IN _table,
    0,
    1
    ),
    1)

     

LWOLF's avatar
LWOLF
Regular Visitor
4 years ago

thanks amitchandak . I actually managed to solve it after many hours of thinking! 😄 

 

Products_exclusion = 
VAR _table = CALCULATETABLE(SUMMARIZE('main','main'[Customer ID]), FILTER(ALL('main'),'main'[Product] IN FILTERS('slicer disconnected'[Product])))
RETURN
IF(
    ISFILTERED(
        'slicer disconnected'[Product]),
IF(     
    MAX('Customer concat'[Customer ID]) IN _table,
    0,
    1
    ),
    1)