Keyword Comparison with Previous Months.

Hi ,

I have used this dax query to find out the New count in power bi desktop:

step 1: I have created a calculated column as t find New vs Common:

KeywordStatus = IF ( NOT ( COUNTROWS ( FILTER ( ALL('BT3 Keyword (2)'), 'BT3 Keyword (2)'[Keyword] = EARLIER('BT3 Keyword (2)'[Keyword]) && 'BT3 Keyword (2)'[Month Id] < EARLIER('BT3 Keyword (2)'[Month Id]) ) ) ), "New", "Common" ) ​

step 2:
I have created a measure to find out Distictcountof New keyword as:
NewC = CALCULATE( DISTINCTCOUNT('BT3 Keyword (2)'[Keyword]), FILTER( 'BT3 Keyword (2)', 'BT3 Keyword (2)'[KeywordStatus] = "New" ) ) 

I got the exact distinct count as I have worked on excel in overall scenario by using this steps,
but when I make table with management group and NewC then it is showing lesser value.

Is this because of I have different different management group

and suppose I have keyword that is present in all managemnet group so this dax are using

distictcount of one for all management group or any specific management group.

I want to calculate all keyword for every management group if it is showing for one management group

then also count it for that or if it is showing for all management group then count in all managment group.

Thanks,

Arvind