Need help on the DAX formulation

Hi lavadba

Based on your description, I have created a simple sample:

Please try:

First create three measures:

Count Last Month = COUNTX(FILTER('Table',MONTH([Date])=MONTH(TODAY())-1),[User])

Count Before = COUNTX(FILTER('Table',MONTH([Date])<MONTH(TODAY())-1),[User])

Count 6 Month Before Last Month = COUNTX(FILTER('Table',MONTH([Date])<MONTH(TODAY())-1&&MONTH([Date])>MONTH(TODAY())-8),[User])

Then create a new table with [User] Column and rename it:

Apply the measures to the visual level filter:

Recreate a new table for users who didn’t use it for over 6 months before Last month and apply filter: