Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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

 

 

 

 

QUICKMEASURE
  • Anonymous's avatar
    Anonymous
    4 years ago

    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