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 t...
Need Help
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.