Forum Discussion
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...
the solution for this question is posted at the above link. Thanks for everyone helped.
LP2803 , Create a new column like
if(sumx(Filter(table, [MeetingInstanceID] = earlier([MeetingInstanceID])),if([Value]>5,1,0))>3,1,0)
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.