Need total of calculated if condition measure

[Rajendrabobade]

Hello,

I need a total of calculated measure(formula 2) for example :

Formula 1 -divide(sales ]),DATEDIFF(MAX('Calendar'[Start Year]),MAX('Calendar'[Date]),MONTH) +1 )

Formula 2- if(formula 1>=300,1,0)

In below table i need formula 2 total sholud be 1+1 = 2 but still  showing 0 please guide me for this .

sales	formula 1	formula 2
500	250	0
700	350	1
800	400	1
Total - 2000	Total - 1000	Total -0

kindly help me .

Thank you

[amitchandak · Accepted solution]

@Rajendrabobade , if(formula 1>=300,1,0)

Need a context , so if do not give that, if will re calculate at grand total level

assume you have a group by in visual you can try

sumx(Summarize(Table, Table[Column], "_1",if([formula 1]>=300,1,0)),[_1])

refer: https://www.youtube.com/watch?v=qE5KBp4uP0g