Group by column and to get other column

[Sonalim]

I am trying to group by requisition -code and then want to get max requisition id with respect to that code,and some other column data with respect to that  requisition code ,i tried a lot but not getting the answer,

please help me in this regard grp by rqstn code,want max no of rqstn id

[Sonalim]

Actually i want like count of requisition code after( group by requisition code ,with max restn id ) with some other column condition also

[audreygerred]

You can just create a count measure for the count. For example, in a matrix, put requisition code in rows. In values you can put the measure I gave you that will give you the max ID, then you can add the measure for count of IDs, and whatever other elements you want 🙂

[audreygerred]

Hi! Try below:

Req ID Max =

CALCULATE (

    MAXX (

        VALUES('Table'[Requisition_Code]),

            MAX('Table'[Requisition_ID])

        )

    )