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).  ...
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.

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..