Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Group by measure

Hello, I need to create a group from a measure.

 

I want to count the number of items in a PO (see results in the middle table) and then group those results and count the number of occurences of each (See table to the left).

 

How can I do that?

 

 

Thank you

 

Need Help
Tips and Tricks

1 Reply

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

    Anonymous , Assume you have measure

     

    Bucket/Segment code
    measure
    Measure =  [Measure 2]

     

    Create a table 

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

     

    then create a new measure

    new Measure
    Countx(filter(Values(Table[Equite]), [Measure ] = max(bucket[Value])), [User])

     

    Display with value column of new table

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