comparing two columns

[fab196]

HI ,

CAN anyone help me with this problem

my data is listed below

what i want :

i want table chart result if the column are nt matching then and then the number of rows should be displayed.

for example in my data:

country	state	Mg1	mg2
in	mh	p	d
in	kr	p	p
us	mi	p	p
us	ca		p

for example in my data ,coutry , mg1 and mg is there.if mg1 value <> mg2 then and then result should be shown otherwise not and if tone the mg1 and mg2 feild have null values then this row
should be ignore.

so the final result should be

country	state	Mg1	mg2
in	kr	p	p
us	mi	p	p

please help

@parry2k 

@amitchandak 

[amitchandak · Accepted solution]

@fab196 , The result is showing mg1 = mg2 in the output table you shared.

Add this measure with other columns

countrows(filter(Table, [Mg1] = [mg2] && not(isblank([Mg1])) && not(isblank([mg2]))))

[fab196]

THANK YOU GENIOUS!