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
You don't need to use the MAX() function. Just drag the Requestion Event ID to a table and then in the dropdown in the Values section on the right, tell it "Don't summarize"
Then use the following measure to count the number of Requestion IDs for each Event ID.
Requistion ID Count = COUNT('eta requisition_life_cycles'[requisition_id])
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
- edhans7 years ago
Community Champion
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.