Crossfiltering tables ignoring filters in one table

[dmount33]

Table X is a simple table with product_id, product_title, and a ranking for the date determined by a slicer. The user selects a date, and the table shows the ranks for each item. 

Now we'd like to add a chart next to the table, showing the ranking position over time, for the selected item in the table. However, because Table X is filtered on a date, the chart only reflects the ranking for that date. 

I've tried a handful of measures around VALUES, SELECTEDVALUE, ALL, ALLEXCEPT, but can't get it to function they way we'd like. 

Backend Data would look something like 

[parry2k]

@dmount33 it will be easier if you throw a sample data and the existing measure used for ranking, and also how tables are connected, it will help to provide the solution.

[dmount33]

In this case rank isn't calc'd, it's just the rank of a product on a listing page which comes out of a script, effectively a str. And just the one table, nothing connected (yet)

[v-chenwuz-msft]

Hi @dmount33 ,

Maybe you can try the following code in your case. I use other functions regardless rankx().

Measure = 
VAR _a =
    SUMMARIZE(
        FILTER(ALL('Table'),[d_data]=SELECTEDVALUE('Table'[d_data])),
        [product_title],
        "minrank", MIN( 'Table'[p_rank] )
    )
VAR _r =
    ADDCOLUMNS( _a, "newrank", RANKX( _a, [minrank],, ASC ) )
RETURN
    MINX(
        FILTER( _r, [product_title] = MAX( 'Table'[product_title] ) ),
        [newrank]
    )

result:

Pbix file in the end you can refer.

Best Regards

Community Support Team _ chenwu zhu

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