Countrows on a measure

[delmayhan]

Hi All, 

i have a simple table with 2 columns

i created a measure and used countrows 

What i wanted to do next is to countrow on the created measure Countrows on how many times the Countrows occured as seen as below.

 How can i create a new measure/column on the countrows measure that i already have created.

Greetings

[amitchandak · Accepted solution]

@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

[Anonymous · Accepted solution]

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.

[Anonymous · Accepted solution]

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.

[delmayhan · Accepted solution]

Hi Eyelyn,

This worked thanks!

[amitchandak · Accepted solution]

@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

[delmayhan]

Hi Amith,

it didnt work. I created a new Table and did this bucket = Generateseries(1,100,1)

After that i tried to create a new measure but it didnt work.