CALCULATE Formula

[Anonymous]

Hi Guys. Got a simple problem, however, for the life of me, I can't seem to work it out. 

Basically I've got two tables. One has Total Caseload (Caseload Table) and another one has certain requirements for clients (Job Search Table). 

I am trying to come up with a number and percentage to show out of total caseload, how many clients with stream "SC" (caseload table) have got Job Search requirement of more than 10 (Job Search Table). 

So far I've tried this formula (which might need tweaking): 

I thought in order to calculate the number of such cohort I could do this formula: 

Any help would be appreciated (a brief explanation of the solution would help too)

[amitchandak · Accepted solution]

@Anonymous in place of && use comma , or use two separate filter one on each Table

example

Calculate([Measure], Table1[A] = "ABC", Table2[B] >100)

Calculate([Measure], filter(Table1, Table1[A] = "ABC") ,filter( Table2, Table2[B] >100) )

[Anonymous]

Hi @amitchandak . Mate thank you so much for your help. both formulas worked a treat. Cheers for your help