cancel
Showing results for
Did you mean:

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

## n value in colum

Maximum

Measure = MAXX(KEEPFILTERS(VALUES(TableNameOrColumnName)),CALCULATE(COUNTA(ColumnName)))

Minimum

Measure = MINX(KEEPFILTERS(VALUES(TableNameOrColumnName)),CALCULATE(COUNTA(ColumnName)))

Pura vida!

Maximun

Original column named A, has the number 2 repeated 142 times (quickmeasure) Maximum

Minumum

Original column named A, has the number 28 repeated 1 times (quickmeasure) Minimum

1 ACCEPTED SOLUTION

Hi, sure is just a tip, in order to find the n quantity of times that any number is repeated in the column.

2 REPLIES 2
Super User

@mchacon ,The information you have provided is not making the problem clear to me. Can you please explain with an example.

Refer if Rank or TOPN can help

Hi, sure is just a tip, in order to find the n quantity of times that any number is repeated in the column.