How to get a slicer to propagate throughout a M2M Table Arrangement.

Greetings

I believe a picture and the code I used will highlight my problem so let me begin. The 1st picture is the M2M table relationship I created.

M2M.JPG

Also, I have used an approach by Rob Collie/Avicvhal Singh from their book "Power Pivot & Power BI", Page 227, and the excellent reference by SQLBI, "the Many-to-Many Revolution."

In the BRIDGE table it is suggested to use the CROSSFILTER function (not using Power BI, just regular excel) to force and redirect the 1-M relationship in both directions. This works as proposed.

Here is that DAX code in the bridge table "Sch_Asset_Freq".

FUSFlagCrosstBL:=CALCULATE([GFEBS FACILITIES],
CROSSFILTER(Sch_Asset_Freq[ASSET GROUP], AssetGrp[ASSET GROUP], Both)
)

The additional DAX code in table "Schedule" is - Asset Qty by Schedule:=CALCULATE([GFEBS FACILITIES],Sch_Asset_Freq)

I know this is working as expected because I have created a slicer (Slicer_ASSET GROUP) at the table "AssetGrp" (the upstream table), and this slicer filters the next table "GFEBS_IDS_ALLSITES." The pivot table is acting normally.

My problem is with the slicer I created at the upstream table, "Schedule" (Slicer_Schedule) which is not propagating the slicer filter all the way throughout the tables.

Finally, It is hoped the file attached will be displayed properly to show the details of the table arrangement.

All, let me add some additional information in the form of a pivot table.

Attachment 713758

The pt begins with elements from tbl Schedule all the way through to GFEBS_IDS_ALLSITES bringing information together through the relations correctly.

What I cannot do is slice the data from Slicer_SCHEDULE (three elements) and have that selection propagate through the M2M relationship to filter the last table with elements from tbl Asset Group that was filtered from the slicer.

Any suggestions to making this slicer work? Thanks.