+ Reply to Thread
Results 1 to 1 of 1

DAX Filter on two different tables

  1. #1
    Forum Contributor
    Join Date
    08-03-2021
    Location
    London
    MS-Off Ver
    365
    Posts
    594

    DAX Filter on two different tables

    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.

    Please Login or Register  to view this content.
    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
    Attached Files Attached Files
    Last edited by Dicken; 06-08-2022 at 10:47 AM. Reason: Forgot tags

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Filter multiple tables and columns and automaticall add new tables to macros
    By HarleyRidesBMX in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-29-2021, 10:18 AM
  2. Filter multiple tables and columns and automaticall add new tables to macros
    By HarleyRidesBMX in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-29-2021, 10:10 AM
  3. Filter multiple tables and columns and automaticall add new tables to macros
    By HarleyRidesBMX in forum Access Tables & Databases
    Replies: 2
    Last Post: 08-29-2021, 10:08 AM
  4. [SOLVED] I need formula or macro to filter a number of items from different tables at single filter
    By Karthikeyannb in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-05-2014, 11:04 AM
  5. One filter/ Master filter multiple pivot tables based on worksheet...
    By jlworden in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 04-10-2013, 11:16 AM
  6. Duplicate Report Filter and Row Labels Filter Across Multiple Pivot Tables
    By tash in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-25-2013, 05:32 PM
  7. Filter several pivot tables by one programmed date range filter in Excel 2003
    By olewka in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-08-2011, 11:49 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1