Forum Discussion

nbs33's avatar
nbs33
Helper II
3 years ago

Measure slicer not filtering table correctly

Hi,   I am segementing customers into categories based on time periods, and by specific flags in the data set. I have confirmed my logic for the categories is correct and the counts of customers in...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Community Champion
3 years ago

nbs33 I'm not entirely sure what you are going for here exactly, but your Buckets Slicer isn't connected to any tables. That means you have to form the relationship in the Measure. Your Retained and Organic measures work but there's something off about your Lost and Acquired measures. You basically need a measure along the lines of below but you'll also have to fix your Lost and Aquired measures to work more like your Retained and Organic measures. PBIX is attached below signature.

Measure = 
    VAR __Group = SELECTEDVALUE('Buckets Slicer'[Groups])
RETURN
    SWITCH(__Group,
        "All",COUNTROWS(DISTINCT(ALL('BoB'[CustomerKey]))),
        "Lost",[Lost],
        "Retained",[Retained],
        "Organic",[Organic],
        "Acquired",[Acquired],
        BLANK()
    )
nbs33's avatar
nbs33
Helper II
3 years ago

Greg_Deckler thanks for the response. I was using a table filter to create that relationship to my disconnected slicer but that didn't work

 

 

Not sure what could be wrong with my Lost and Acquired because the out is just a list of Customers. 

 

I've been struggling with this issue for awhile. Any other apporaches your can think of? Since I have a time dimension slicer I can't use a calculated table.

 

Thanks again!