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
v-lionel-msft's avatar
v-lionel-msft
Community Support
5 years ago

Hi LP2803 ,

 

Or create a measure like this.

Measure = 
VAR __sum = 
SUMX(
    FILTER(
        ALLSELECTED(Sheet1),
        [MeetingInstanceID] = MAX([MeetingInstanceID]) && 
        [Attribute2] = MAX([Attribute2]) &&
        [ParticipantsName] = MAX([ParticipantsName])&&
        [if >5?] = 1
    ),
    [if >5?] 
)
RETURN
IF(
    __sum > 3,
    1, 0
)

 

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

  • LP2803's avatar
    LP2803
    Responsive Resident
    5 years ago

    v-lionel-msft Hi lionel, thanks for the response.

     

    I have multiple attributes, like  Latency, Packetloss, framerate etc which i need to include.

     

    For example count the participant in a meeting who has got Packetloss of morethan 5 for 3 times.

    Likewise count the participant in a meeting who has got Latency of morethan 400 for 3 times.

     

    Any idea how I can do this in one query without create a extra columns