Find repetitive values over different months in different categories

[Anonymous]

Hi, 

I have a dataset simplified as below, and have a requirement to highlight repetitive amounts, per category per store.

How Can I do that with DAX please ? 

Your help is very appreciated, 

Thanks in advance

[Jihwan_Kim · Accepted solution]

Repeated ? : =
VAR currentvaluetotal = [Value Total :]
VAR currentmonth =
MAX ( Months[Index] )
VAR newtable =
FILTER (
ALL ( Sales ),
Sales[Store] = MAX ( Stores[Store] )
&& Sales[Category] = MAX ( Categories[Category] )
&& [Value Total :] = currentvaluetotal
&& RELATED ( Months[Index] ) < currentmonth
)
RETURN
IF ( ISFILTERED ( Months[Index] ), IF ( COUNTROWS ( newtable ) >= 1, 1, 0 ) )

https://www.dropbox.com/s/4ybuju3e2nvpuko/mazer.pbix?dl=0 

[Anonymous]

Hi @Jihwan_Kim 
Thank you for the solution,

I'm applying your solution to my datase, but in the last condition, I'm getting the condition: ISFILTERED ( Months[Index] ) = False .. Any thoughts or Ideas ?

[Anonymous]

Thanks a lot @Jihwan_Kim