DAX full syntax for filter

Hi,
This question is also posted on Mr Excel

Please Login or Register  to view this content.

Could some one explain the full syntax for :

Please Login or Register  to view this content.

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

Please Login or Register  to view this content.

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:

Please Login or Register  to view this content.

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.