Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Disconnect Table to filter data and visuals based on selection

Hi Experts

 

Not sure on how to tackle the following problem i am trying to use my dis connected table _Trend to filter the date in the two visulaisations as show in the pbix file (first table).

 

So if the user selects No Trend then only show data points in the table that say No Trend and the filtered values in the table below.

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

Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    7 years ago

    Hi Anonymous 

    You want "PMSComplaintsMN" measure to show values of "No Trend" when selecting ""No Trend", right?

     

    From your measure

    Significance Y = IF(
   '_Measures'[p-value] <= 0.05, "Significant Trend",
   "No Trend"
)

    It seems "No Trend" means  '_Measures'[p-value] > 0.05

    If so, you could create "PMSComplaintsMN" measure as below:

    PMSComplaintsMN =
CALCULATE (
    IF (
        ISBLANK ( COUNTA ( 'PMS_COMPLAINT'[MATERIAL_ID] ) ),
        BLANK (),
        COUNTA ( 'PMS_COMPLAINT'[MATERIAL_ID] )
    ),
    FILTER (
        ALLSELECTED ( PMS_FINANCIAL_PDS[ROLL12_COMPLETE_PDS_IND] ),
        '_Measures'[p-value] > 0.05
    )
) + 0

    (ps: if your file contains some important information or private information, please delete it from here, next time, if you need to share files,  just share a simple example)

     

    Best Regards
    Maggie

     

    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

4 Replies

  • v-juanli-msft's avatar
    v-juanli-msft
    Icon for Community Support rankCommunity Support
    7 years ago

    Hi Anonymous 

    You want "PMSComplaintsMN" measure to show values of "No Trend" when selecting ""No Trend", right?

     

    From your measure

    Significance Y = IF(
   '_Measures'[p-value] <= 0.05, "Significant Trend",
   "No Trend"
)

    It seems "No Trend" means  '_Measures'[p-value] > 0.05

    If so, you could create "PMSComplaintsMN" measure as below:

    PMSComplaintsMN =
CALCULATE (
    IF (
        ISBLANK ( COUNTA ( 'PMS_COMPLAINT'[MATERIAL_ID] ) ),
        BLANK (),
        COUNTA ( 'PMS_COMPLAINT'[MATERIAL_ID] )
    ),
    FILTER (
        ALLSELECTED ( PMS_FINANCIAL_PDS[ROLL12_COMPLETE_PDS_IND] ),
        '_Measures'[p-value] > 0.05
    )
) + 0

    (ps: if your file contains some important information or private information, please delete it from here, next time, if you need to share files,  just share a simple example)

     

    Best Regards
    Maggie

     

    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago
      Hi Maggie. I believe so. Let me test looks good from here and come back to you. Excellent feedback as always
    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago
      Hi Maggie.

      All your assumptions are correct how would you do the measure for significant trend. When p-value is <=0.05. Same question when selecting filter significant trend from disconnect table..