Visual and page filters not working

[Anonymous]

wow, I can't upload my project file here..... huh this is going to make things difficult

Two tables with a relationship.  Table A has an amount column and I have a donut chart summing that amount by name.

Table B is a related table.

Table B has a column that I wish to filter the donut chart on

I only get 1 result  This is the generated DAX I caputed from Performance Analyzer

 // DAX Query
DEFINE
  VAR __DS0FilterTable = 
    TREATAS({"A"}, 'Table2'[Type])

it goes south here as this returns just 1 record so the TOPN is performed on a table of 1
  VAR __DS0Core = 
    SUMMARIZECOLUMNS('Table1'[Name], __DS0FilterTable, "SumAmount", CALCULATE(SUM('Table1'[Amount])))

  VAR __DS0BodyLimited = 
    TOPN(1002, __DS0Core, [SumAmount], 1, 'Table1'[Name], 1)

EVALUATE
  __DS0BodyLimited

ORDER BY
  [SumAmount], 'Table1'[Name]

I'd upload the project because that would be simplier but I see no upload link.

[TomMartens]

Hey @Anonymous ,

upload the pbix file to onedrive or dropbox and share the link.

Regards,

Tom

[Anonymous]

https://app.box.com/s/wgbtm5di39ajag03tl5evzislqw0wfna 

[Anonymous · Accepted solution]

I changed the properties on the relationship.  The value for Cross Filter Direction was changed to "Both" and configured the filter for both directoins (checkbox) and now appears to be functioning.

[v_mark]

I had the same situation but little different . 
My date table and category table in my filters on this page does not work. 
Date table filter supersede the category filter looking that category doesn't exist. 
Weird thing is I do have that category and a row in my fact table but for some reason it doesnt show. 

I end up using the cross filter set to both and it works.