Dax measure

Hi, Anonymous 

 

Since the sample you share is not representative and you didn't give the desired results, I can only follow my ideas.

Yo can create the measures.

Like this:

Total = 
COUNTROWS (
    FILTER (
        ALL ( 'Table' ),
        [Country ID] = SELECTEDVALUE ( 'Table'[Country ID] )
            && YEAR ( [Go Live] ) = YEAR ( MAX ( 'Table'[Go Live] ) )
            && MONTH ( [Go Live] ) = MONTH ( MAX ( 'Table'[Go Live] ) )
    )
)

3/4 total = 
VAR a =
    EOMONTH ( MAX ( 'Table'[Go Live] ), 0 )
RETURN
    COUNTROWS (
        FILTER (
            ALL ( 'Table' ),
            [Country ID] = SELECTEDVALUE ( 'Table'[Country ID] )
                && [Go Live] >= a - 6
                && [Go Live] <= a
        )
    )

Percentage =
DIVIDE ( [3/4 total], [Total] )

You can put the country id and go live column in table visual.

 

Did I answer your question? Please mark my reply as solution. Thank you very much.
If not, please feel free to ask me.

Best Regards,
Community Support Team _ Janey