SummarizeColumns Query with Filters Or/And

Question

I have a SummarizeColumns query which works fine but I would like to have and or logic in the Filter on 2 different dimensions. What I am trying to do is to have the logic where (tracking prefix =&nbsp;016162 and person id =&nbsp;5489552) or (tracking prefix =&nbsp;016835). I could do it in 2 queries and merge them but I was trying to work out how to do it in one go. Any ideas?&nbsp;EVALUATESUMMARIZECOLUMNS (&nbsp;&nbsp;&nbsp;&nbsp;'Tracking Prefix'[Tracking Prefix],&nbsp;&nbsp;&nbsp;&nbsp;Route[DC Id],&nbsp;&nbsp;&nbsp;&nbsp;Company[Company Id],&nbsp;&nbsp;&nbsp;&nbsp;FILTER (&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ALL ( Route[DC Id] ),&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;CONTAINSROW (&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;//{ 191 },&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;{ 95, 89, 92, 96, 94, 90, 91, 321, 93, 191, 2180, 2575, 180 },&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Route[DC Id]&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;)&nbsp;&nbsp;&nbsp;&nbsp;),&nbsp;&nbsp;&nbsp;&nbsp;FILTER ( Company, Company[Company Id] = 3222 ),&nbsp;&nbsp;&nbsp;&nbsp;FILTER (&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ALL ( 'Tracking Prefix' ),&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;CONTAINSROW ( { "016162","016835" }, 'Tracking Prefix'[Tracking Prefix] )&nbsp;&nbsp;&nbsp;&nbsp;)&nbsp; &nbsp; ,&nbsp;FILTER ( Engineers, Engineers[Person Id] = 5489552 ),&nbsp;&nbsp;&nbsp;&nbsp;FILTER (&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;'Date',&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;'Date'[Date]&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&gt;= DATE ( YEAR ( NOW () ) - 2, 01, 01 )&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&amp;&amp; 'Date'[Date]&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt; DATE ( YEAR ( NOW () ), MONTH ( NOW () ), DAY ( NOW () ) ) --&amp;&amp; 'Date'[Current Week] &lt;&gt; "CurrentWeekByBox"&nbsp;&nbsp;&nbsp;&nbsp;),&nbsp;&nbsp;&nbsp;&nbsp;"Total Ops Deliveries", [Ops Total Deliveries],)

owenauger · Accepted Answer

Hi&nbsp;gooranga1&nbsp;
You could use some examples from this page, particularly examples #12 or #13:
https://www.sqlbi.com/articles/filter-arguments-in-calculate/
&nbsp;
Using example #12, the DAX for that particular filter could look something like:
FILTER (
	CROSSJOIN (
		ALL ( 'Tracking Prefix'[Tracking Prefix] ),
		ALL ( Engineers[Person Id] )
	),
	'Tracking Prefix'[Tracking Prefix]
		IN { "016162", "016835" }
		|| Engineers[Person Id] = 5489552
)
&nbsp;
Regards,
Owen

Forum Discussion

SummarizeColumns Query with Filters Or/And

2 Replies

Related content

Multiple Filters AND and OR

Simplifying a SUMMARIZECOLUMNS with FILTERS EVALUATE query

Alias on SummarizeColumns

SummarizeColumns with Multiple Filters

SUMMARIZECOLUMNS' filters overrides ALLEXCEPT?