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