how to fetch the most repeated value from two existing different column

[Girish_123]

I need to fetch a value between two columns like from columns 1 and columns 2 which is most repeated   i need that one. (eg. Suppose
columns 1 columns 2
A.                  A
B.                 B
A.                 C
C.                  A
D.                  B
A.                  B
A                  D

So here most repeated value is A ( A is repeated 6 times ) like this solution I need.

[smpa01 · Accepted solution]

@Girish_123  you can use this measure to find the mode

_Measure = 
VAR _0 =
    UNION (
        SELECTCOLUMNS ( 'Table', "c1", 'Table'[column1] ),
        SELECTCOLUMNS ( 'Table', "c1", 'Table'[column2] )
    )
RETURN
    MINX (
        TOPN (
            1,
            ADDCOLUMNS (
                _0,
                "Frequency", COUNTX ( FILTER ( _0, EARLIER ( [c1] ) = [c1] ), [c1] )
            ),
            [Frequency]
        ),
        [c1]
    )

[Girish_123]

I'll try this one thank you so much