Hi,
I've been trying various way of filter a fact table by two or more lookup tables,
I've attached full examples, I'd used keepfilters and Values, but to return a two columns table to filter I was using Crossjoin,
which worked fine, but then I used Summarize, and this seems to mean that you don't need keepfilters in order to have an 'AND'
operation with the external filter in the pivot table.
I've put this into Studio to get an idea of what's been returned, but aren't too sure as to why the Keepfilter is or does
not seem to be needed where crossjoin would,
as usual suggestion or things to reap up welcome.
Richard
Bookmarks