Forum Discussion
Summarize data according to max event_id
- 7 years ago
hi, Anonymous
After my test, you may try to this way as below:
Step1: Add a calculate column
Use EARLIER Function to find MAX("requisition_event_id") for each "requisition_id"
MaxEventID = CALCULATE ( MAX ( 'eta requisition_life_cycles'[requisition_event_id] ), FILTER ( 'eta requisition_life_cycles', 'eta requisition_life_cycles'[requisition_id] = EARLIER ( 'eta requisition_life_cycles'[requisition_id] ) ) )Step2: Add a calculate measure
Add a measure that Count (requisition_id)
Count of requisition_id = CALCULATE(COUNTA('eta requisition_life_cycles'[requisition_id]))Step3: Create a visual
Drag the field MaxEventID and measure Count of requisition_id into visual
Best Regards,
Lin
edhans as you can see there are n numbers of requisition_event_id for one requisition_id. i need max event id for requisition_id then i need count of requisition_id for that max event ids
Ok. See if this file is what you need. I used Power Query to determine the Max Event ID for each type of requestion ID in a separate table that is NOT loaded. Then I merged that table back to the original table, then used a simple COUNT() measure.