TOPN 3 latest sale -other pattern

[BrianJ]

@matty,

Here’s the way I would tackle this in a general sense:

1. create a disconnected date table slicer
2. harvest the values of that
3. build a RANKX-based measure with a variable that returns a one column table containing top three dates, subject to the filter condition set by the harvested values from 2). The result of that measure will check each selected date value in the visual to see whether that value is in the one column table variable, and the measure will return a 1 if it is, and a 0 if not.
4. throw the measure created in 3) into the filter pane for the relevant visuals (either at the individual visual level, or at the page level) and set it equal to 1.

I hope this is helpful, and puts you on the right track to a solution.

• Brian

P.S. While not a RANKX-based problem, this solution that I provided yesterday uses all the other aspects of the strategy I laid out above.

Calculate total sales of baskets that contain one item

@mazhowitt, OK, @jbressan got in quicker, but because it’s always valuable to see how different people addressed the same problem, here’s my solution. I used a disconnected table slicer on Item # (and instead of a standard slicer, I used the custom SmartFilter Pro - a custom visual I really like that handles this sort of data really well IMO). Then, here’s the measure that does most of the heavy lifting: Customers Who Bought = //Filters the Sales Table Down to Purchases of the Selected Ite…