Forum Discussion

delmayhan's avatar
delmayhan
Frequent Visitor
4 years ago
Solved

Countrows on a measure

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

 

Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    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's avatar
    Anonymous
    4 years ago

    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.

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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's avatar
      delmayhan
      Frequent Visitor
      4 years ago

      Hi Eyelyn,

       

      This worked thanks!

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    4 years ago

    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's avatar
      delmayhan
      Frequent Visitor
      4 years ago

      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.