Slicer not filter data in table - Dis connect table

[Anonymous]

Hi Experts

I cannot see the error here, i have a dis connect table (_trendsdirecrtion) using the measure NoTrend_Significants, the measure give the correct overall values when neither NO Trend or Significant Trend are not selected.

However, when i select either No Trend and or Significant Trend the bottom graph is not producing the correct result, just returning 0 values for each period.

see sample file:

https://www.dropbox.com/s/im9d8gxvounf6fc/Sample__v.1.16.pbix?dl=0

[dax]

Hi Rout217,

In your sample, I find that your meausre of Significant Trend is always show 0

It seems that there is no relationship between meausre and month field. I will try to understand your logic and inform your as soon as I get it.

Thanks for your understanding and support.
Best Regards,
Zoe Zhi

[Anonymous]

hi zoe

Should i close the question?

[Anonymous]

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]

[Anonymous]

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

[Anonymous]

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