Slicer not filter data in table - Dis connect table

Hi Zoe

Here is a more detailed file with other relationships in the data model which may or may not help. https://www.dropbox.com/s/nbdtigc4rdbkfzp/Sample__v.1.18.pbix?dl=0

Hi Zoe, apologies and sorry to be a pain any further developments?

Hi Community Team (zoe)

i just did the following Steps. I selected Product ID72201092 went to View on tool bar selected Performance Analyzer > Start Recording > Selected the Products Complaints Totals with Trend Direct Table 

Then Select copy Visual, this gave me the DAX code which allows me to cross filter. Here is the code. Surely the answer must lie here, on how we can count the data poiints that are significant and those that have No Trend.

DEFINE =
  VAR __DS0FilterTable = TREATAS({"Y"}, 'PMS_FINANCIAL_PDS'[ROLL12_COMPLETE_PDS_IND])

  VAR __ValueFilterDM0 = FILTER(
      KEEPFILTERS(
        SUMMARIZECOLUMNS(
          'PMS_PARTS'[Product],
          __DS0FilterTable,
          "p_value", '_Measures'[p-value],
          "v__trend", '_Measures'[__trend],
          "ArrowY", 'URLImages'[ArrowY],
          "Significance_Y", '_Measures'[Significance Y],
          "TAU", 'PMS_FINANCIAL_PDS'[TAU],
          "NoTrend_Significants", '_TrendsTable'[NoTrend_Significants]
        )
      ),
      [NoTrend_Significants] > 0
    )

  VAR __DS0Core = 
    SUMMARIZECOLUMNS(
      'PMS_PARTS'[Product],
      __DS0FilterTable,
      __ValueFilterDM0,
      "p_value", '_Measures'[p-value],
      "v__trend", '_Measures'[__trend],
      "ArrowY", 'URLImages'[ArrowY],
      "Significance_Y", '_Measures'[Significance Y],
      "TAU", 'PMS_FINANCIAL_PDS'[TAU],
      "NoTrend_Significants", '_TrendsTable'[NoTrend_Significants]
    )

EVALUATE
  GROUPBY(
    __DS0Core,
    "MinNoTrend_Significants", MINX(CURRENTGROUP(), [NoTrend_Significants]),
    "MaxNoTrend_Significants", MAXX(CURRENTGROUP(), [NoTrend_Significants])
  )

EVALUATE
  TOPN(501, __DS0Core, 'PMS_PARTS'[Product], 1)

ORDER BY
  'PMS_PARTS'[Product]

hi zoe

Should i close the question?