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)

     

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

LWOLF , Make sure independent table for the product is used in slicer, I changed the name to product

 

try measure

 

Customer concat =
var _cust = except(all(main[Customer ID]) , SUMMARIZE(filter('main',main[Product] in VALUES(Product[Product])), main[Customer ID]))
return
countrows(filter(main, main[Customer ID] in _cust ))

 

plot this with customer

  • 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)