HOW TO GET TOTAL TARGET PER MONTH

[RanHo]

Good Day! Can someone help me how to get the total count of target per month base on this sample data:


so basically I want to ge the total count of target of JAN with the total of 100, can someone tell how? 
Thanks in advance!

[amitchandak · Accepted solution]

@RanHo ,  Try measures like

calculate(sum(Table[Target]), allexcept(Table, Table[Month]) ) 

or

calculate(sum(Table[Target]), filter(allselected(Table), Table[Month] = max(Table[Month])  )  )