Filtering by Multiple Columns (not AND, but OR)

Question

Hi&nbsp;Really not sure how to start with this I am going around in circles.&nbsp;I have tracking table like this...&nbsp;TRACKING TABLE:PROJECT_NUMTrack by Account #Track by Part #Track by order #abc123456374728nullnullabc123457nullUH-MADEUP-3nullabc123458nullUH-MADEUP-2000nullabc123459nullnull34A09024abc123460nullnull34A09125abc123461276984nullnullabc123462nullnull20B07098abc123463nullnull54YB0D63abc123464nullnull54YB0HGJabc123465nullnull1X5B15XYabc123466nullnull1X5B165Xabc123467nullnull1X5B15QWabc123468166995nullnullabc123469155542nullnull&nbsp;INVOICE TABLE:Track by Account #Track by Part #Track by order #374728Part 134A09999145525UH-MADEUP-356554645145525UH-MADEUP-200065666626365662Part 134A09024234141Part ABV34A09125276984Part ABV53255252466622Part ABV20B07098754775Part fdgfds54YB0D63524325Other Park54YB0HGJ475473XYZ Part1X5B15XY475473AAAA-Part1X5B165X475473AAAA-Part1X5B15QW166995XXXXX-PN32553256155542XXXXX-PN43643243&nbsp;I want to be able to&nbsp;use the TRACKING TABLE to filter the rows of the invoice table, where ever there is a match on ANY column.&nbsp;Seems obvious but I am lost with it, not even sure what to search for in terms of help.&nbsp;&nbsp;Any suggestion welcome.

johnshepherdapd · Answer

Hi there,create inactive relationships like this:&nbsp;with a measure like this:&nbsp;&nbsp;VAR _TblAccount =
    UNION (
        CALCULATETABLE (
            'Invoice Table',
            USERELATIONSHIP ( 'Invoice Table'[Track by Account #], Tracking[Track by Account #] ),
            NOT ( ISBLANK ( Tracking[Track by Account #] ) )
        ),
        CALCULATETABLE (
            'Invoice Table',
            USERELATIONSHIP ( 'Invoice Table'[Track by order #], Tracking[Track by order #] ),
            NOT ( ISBLANK ( Tracking[Track by order #] ) )
        ),
        CALCULATETABLE (
            'Invoice Table',
            USERELATIONSHIP ( 'Invoice Table'[Track by Part #], Tracking[Track by Part #] ),
            NOT ( ISBLANK ( Tracking[Track by part #] ) )
        )
    )
RETURN
    COUNTX ( _TblAccount, MAX ( Tracking[PROJECT_NUM] ) )&nbsp;&nbsp;you can use this measure then to filter in visuals where the IsTracked is not blank

Forum Discussion

Filtering by Multiple Columns (not AND, but OR)

1 Reply

Related content

odata Report Level Filters Multiple Filters Same Column

filtering on multiple columns

Single Slicer to Filter Multiple Columns

Multiple Column Filter

Slicer for filtering several columns

PROJECT_NUM	Track by Account #	Track by Part #	Track by order #
abc123456	374728	null	null
abc123457	null	UH-MADEUP-3	null
abc123458	null	UH-MADEUP-2000	null
abc123459	null	null	34A09024
abc123460	null	null	34A09125
abc123461	276984	null	null
abc123462	null	null	20B07098
abc123463	null	null	54YB0D63
abc123464	null	null	54YB0HGJ
abc123465	null	null	1X5B15XY
abc123466	null	null	1X5B165X
abc123467	null	null	1X5B15QW
abc123468	166995	null	null
abc123469	155542	null	null

Track by Account #	Track by Part #	Track by order #
374728	Part 1	34A09999
145525	UH-MADEUP-3	56554645
145525	UH-MADEUP-2000	65666626
365662	Part 1	34A09024
234141	Part ABV	34A09125
276984	Part ABV	53255252
466622	Part ABV	20B07098
754775	Part fdgfds	54YB0D63
524325	Other Park	54YB0HGJ
475473	XYZ Part	1X5B15XY
475473	AAAA-Part	1X5B165X
475473	AAAA-Part	1X5B15QW
166995	XXXXX-PN	32553256
155542	XXXXX-PN	43643243