Forum Discussion
CALCULATE Formula
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 requireme...
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 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) )
Hi amitchandak . Mate thank you so much for your help. both formulas worked a treat. Cheers for your help