Forum Discussion

LP2803's avatar
LP2803
Responsive 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
Super User
5 years ago

LP2803 , Check if this can work

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

  • LP2803's avatar
    LP2803
    Responsive Resident
    5 years ago

    amitchandak thanks. 

    I tried, but i get error "Cannot find name" 

     

    check = if(sumx(Filter('Sheet1 (2)', 'Sheet1 (2)'[Column1.meetingInstanceId] = earlier([Column1.meetingInstanceId]) && 'Sheet1 (2)'[Column1.participantSessionId] = earlier([Column1.participantSessionId])),if([Value]>5,1,0))>3,1,0)

     

     

    Any idea please...