earlier function combine with other columns

[selpaqm]

Hi,

I have a table as below. 

Column uses 

"Column =

VAR _count= CALCULATE(COUNTROWS('Table'),FILTER('Table','Table'[salesman/country]=EARLIER('Table'[salesman/country])&&'Table'[Index]>=EARLIER('Table'[Index])))

VAR _count2=CALCULATE(COUNTROWS('Table'),FILTER('Table','Table'[salesman/country]=EARLIER('Table'[salesman/country])))

return if(_count=_count2,1,0)"

however, in case of method a and b is for same country and salesman need to be written as mixed.

as an example updated method column should be as below.

below you may find the related pbix file

example.pbix 

[Greg_Deckler]

@selpaqm First, DAX Formatter is your friend: https://www.daxformatter.com/

Column =
  VAR __Table = 
    SUMMARIZE(
        FILTER (
            'Table',
            'Table'[salesman/country] = EARLIER ( 'Table'[salesman/country] ),
            [method]
        )
RETURN
    IF ( COUNTROWS(__Table>1, "mixed", MAXX(__Table,[method]) )

If not, share data as text in a table please. 

[selpaqm]

hi @Greg_Deckler 

unfortunately, taken error.

Example.pbix 

at above link you may find my find pbix file.

Regards,

[amitchandak · Accepted solution]

@selpaqm , refer this can work as a new column

Column =
VAR _count= CALCULATE(DistinctCount([Method]) ,FILTER('Table','Table'[salesman/country]=EARLIER('Table'[salesman/country])))+0
return if(_count>1,"Mixed", [method])

[Greg_Deckler]

@selpaqm No access to that file

[selpaqm]

@Greg_Deckler 

can you please retry it.exampl.pbix