Countrows on a measure

delmayhan , You need Bucket/Segment code
measure
Measure = Countrows(Table)

new Table
bucket = Generateseries(1,100,1)

new Measure
Countx(filter(Summarize(Table, Table[Column1], Table[Column2], "-1", [Measure]), [_1] = max(bucket[Value])), [User])

Dynamic segmentation -Measure to Dimension conversion: https://youtu.be/gzY40NWJpWQ

Hi delmayhan ,

Almost the same as amitchandak 's method.

1. A measure to get the count of each Column1 and Column2

Countrows = COUNTROWS('Table') 

2. A new table with number from 1-5:

NewTable = GENERATESERIES(1,5,1) 

3. Calculate the frequency：

Occured = 
var _t= SUMMARIZE('Table','Table'[Column1],'Table'[Column2],"Flag",[Countrows])
return COUNTROWS(FILTER(_t,[Flag]=MAX('NewTable'[Countrows])))

Output:

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi Eyelyn,

This worked thanks!