Forum Discussion
Filter out entries from DirectQuery tables with a sharepoint list
I have been asked to figure out a way to filter out certain sales orders from a large, company wide dataset if they are added to a sharepoint list/excel document. The dataset is a Power BI Semantic ...
You could create a calculation group with a calculation item that filters out the relevant sales,e.g.
Filter Sales =
CALCULATE (
SELECTEDMEASURE (),
NOT 'Remote Sales'[Sale ID] IN DISTINCT ( 'Excel Filter'[Sale ID] )
)
You could then apply this as a page or report level filter.
This seems promising, as it did not result in an error, but the filter does not seem to do anything when applied. I have not played around with calculation groups before, I will look into this more.