DAX filter on two tables

[dicken]

Hi,
I'd like t filter by two tables, very simply I have :



Green and 10+ :=CALCULATE([Total Units],
Color[Color]= "green",
Units[Units] > 10 )
This returns what I thought it would.



So the color from one table is green and the units from the other > 10 , Question 1, what is the 'long syntax' for this, I don't like using the short as
I don't think it's great at getting me to understand how it works, but I've tried various FILTER ( ALL( combinations, and even using two filters but can't get it right.
The second question is that the total for 'green and > 10 " is repeated for the other colors in the table which I'd prefer to to happen.

Richard.

 

[dicken]

Hi,
I'd like t filter by two tables, very simply I have :



Green and 10+ :=CALCULATE([Total Units],
Color[Color]= "green",
Units[Units] > 10 )
This returns what I thought it would.



So the color from one table is green and the units from the other > 10 , Question 1, what is the 'long syntax' for this, I don't like using the short as
I don't think it's great at getting me to understand how it works, but I've tried various FILTER ( ALL( combinations, and even using two filters but can't get it right.
The second question is that the total for 'green and > 10 " is repeated for the other colors in the table which I'd prefer to to happen.

Richard.

z

 

[Fluff]

If you would like to post the solution then it is perfectly fine to mark your post as the solution to help future readers. Otherwise, please do not mark a post that doesn't contain a solution.

 

[Fluff]

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: DAX full syntax for filter
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.