topic Re: how to fetch the most repeated value from two existing different column in DAX Commands and Tips

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

Girish_123 — Thu, 25 Nov 2021 14:55:58 GMT

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.

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

smpa01 — Thu, 25 Nov 2021 15:15:59 GMT

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] )

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

Girish_123 — Thu, 25 Nov 2021 17:09:06 GMT

I'll try this one thank you so much