Forum Discussion

LP2803's avatar
LP2803
Icon for Responsive Resident rankResponsive Resident
5 years ago
Solved

Countrows per multiple columns

Hi Team,   I need a measure or column for getting the below. I want to count per meetingid, per participant, per Attribute,  if Value is greater than 5 and this 5 appears morethan 3 times then giv...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

LP2803 , Create a new column like

if(sumx(Filter(table, [MeetingInstanceID] = earlier([MeetingInstanceID])),if([Value]>5,1,0))>3,1,0)

  • LP2803's avatar
    LP2803
    Icon for Responsive Resident rankResponsive Resident
    5 years ago

    amitchandak Thanks amit, But I also need to consider ParticipantID and the Attribute columns as well.

     

    In the example above, i couldnt show more participantID with same meetingID and attribute but in actual data i have duplicates in meetingid, participants & attribute.