DAX full syntax for filter

Hi,
This question is also posted on Mr Excel

 
 https://www.mrexcel.com/board/threads/dax-filter-on-two-tables.1204409/#post-5881080

Could some one explain the full syntax for :

Simple:=CALCULATE([Total Revenue],
                                                                            'Product'[Color]="Red" , 
                                                                               Sales[Sales] = 10  )

I've tried using various combinations of FILTER (ALL , but none that have worked,


When filtering on just one table I've been able to use

CALCULATE([Total Revenue],
                                                                              KEEPFILTERS(
                                                                                   FILTER(ALL('Product'[Color],'Product'[Product]),
                                                                                                      'Product'[Color]= "Red" && 'Product'[Product]= "A")))

But this doesn't work for two tables. Any suggestions?


Richard.

What is your table relationship?

In general you need two FILTER for two table filtering. Alternately, you may be able to use Calculate() as 2nd condition to supply filter context.
Ex:

Formula:

=CALCULATE([Total Revenue], FILTER('Product','Product'[Color]="Red"), FILTER(Sales, Sales[Sales]=10))

Administrative Note:

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

(Note: this requirement is not optional. No help to be offered until the link is provided.)

Richard - please read the rules. You MUST add a link before anyone can help you further. Thanks.