Forum Discussion
Solved
comparing two columns
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. fo...
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 , 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]))))
THANK YOU GENIOUS!