Disconnect Table to filter data and visuals based on selection

[Anonymous]

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

[v-juanli-msft · Accepted solution]

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]

Hi Maggie

having trouble filerting the below graph same criteria... posted new question

https://community.powerbi.com/t5/Desktop/Slicer-not-filter-data-in-table-Dis-connect-table/m-p/77893...

[Anonymous]

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

[Anonymous]

Hi Maggie. I believe so. Let me test looks good from here and come back to you. Excellent feedback as always