Remove filter using MAX function for column

[cristianml]

Hi,

I need to solve the following measure.  I'm trying to evaluate putting 1 in all the periods that have Revenue amount else 2 into this table.

But as I use MAX for month comparisson is showing only the last month with 1 and I need to remove filters or do this in other way.

I tried with ALL and ALLSELECTED but It doesn't work

Column =

VAR MATCH = IF(MAX('Revenue - CCI'[Month])=NWD_Table[Month] && 'Revenue - CCI'[Revenue]>0,1,2)

RETURN

CALCULATE(MATCH,ALL('00_CALENDAR'))

Any idea?

Thanks  !

[amitchandak · Accepted solution]

@cristianml , You can not use a slicer of filter value in a column. You need to create a measure