Group By basis Sr No

[Anonymous]

I have a data set (Image 1) and I have 2 expectations 1.Group them basis Country and assign same SR Number to one cluster as mentioned in Expected Result 2.Assign the cluster TRUE/FALSE basisthe product value ,for example if USA has diff product so it is FALSE ,India has same product so it is true

[amitchandak]

@Anonymous , add an index column in the power query - Power Query- Index Column: https://youtu.be/NS4esnCDqVw

New dax column =

Min Value = minx(filter(table, [country] = earlier([country]) ), [Index])

S. No = Rankx(Table, [Min Value], ,asc,dense)

True/False =

var _cnt = countx(filter(Table,[country] = earlier([country]) && [prod] <> earlier([prod]) ), [prod])

return

if(isblank(_cnt), true(), false())