New keyword vs Common Keyword

Hi Team,

I have raise this query in power bi community but not got answer.
can you please help me with this?

I have table BT3 Keyword (2) that have column name like Month Id, Management Group, Keyword, Source Name and from this I want to check New keyword count in every current month.. Suppose if Keyword is present in the current month and has no value in any previous month then make it as "New" and If current month keyword present in any of previous month keyword make it as common.

so I have made dax for it .. it is working fine with overall new distictcount when no management group selelcted but when I select any of management group it is giving me lesser value as compare to Excel. Is it beacuse of the keyword is present for other mangement group too ? that is the why my dax not working properly ?

I want every keyword should be count for every management group level.

can you please help me to solve this query?

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 to 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" ) )

Thanks,

Arvind