cancel
Showing results for
Did you mean:

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Helper I

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

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.

1 ACCEPTED SOLUTION
Super User

@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,
_0,
"Frequency", COUNTX ( FILTER ( _0, EARLIER ( [c1] ) = [c1] ), [c1] )
),
[Frequency]
),
[c1]
)``````

Proud to be a Super User!

New Animated Dashboard: Sales Calendar

2 REPLIES 2
Super User

@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,
_0,
"Frequency", COUNTX ( FILTER ( _0, EARLIER ( [c1] ) = [c1] ), [c1] )
),
[Frequency]
),
[c1]
)``````

Proud to be a Super User!

New Animated Dashboard: Sales Calendar

Helper I

I'll try this one thank you so much

Announcements

#### Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

#### Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

#### The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors