CALCULATETABLE to filter fact table using slicer to make multiple selections
I have a fact table containing a list of unique Curricula (Curricula ID) and associated Location Type and Locations. I need to present this in a visual table and filter this visual with a slicer containing only the six sites. I found a way to do this by splitting the fact table of All Curricula into Site Curricula, Regional Curricula and Global Curricula. The method uses one-many and many-many relationships in a data model. I suspect there may be a way to filter the All Curricula table using the same Site Slicer and a CALCULATETABLE. But I don't know how to begin. Thank you
