Forum Discussion

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

Count of rows based on multiple column

Hi Team, First of all, sorry to create this duplicate thread for another thread i have created few days ago.  i'm unable to post screen shot in that thread so creating a new thread.   Below is how...
Need Help
  • AlB's avatar
    AlB
    5 years ago

    LP2803 

    Right. Change it a bit:

    Measure V2 =
IF(SUMX ( DISTINCT ( Table1[ParticipantName] ), [PacketLoss?] ) >0, 1, 0 )

    Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

    Contact me privately for support with any larger-scale BI needs, tutoring, etc.

    Cheers 

     

     

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

currently the latency? packet?  measures (with below DAX)  i have in the view are working fine but not considering the participantname in them. 

 

PacketLoss? = if(COUNTROWS( FILTER(
Filter('Sheet1 (2)','Sheet1 (2)'[Attribute.2]="packetLoss"),
'Sheet1 (2)'[Value]>5)) > 3,1,0)

 

For example, in the second image, I have a matrix visual where I have given the drilldown from meetinginstandid to participantname.

Here, for some meetinginstanceids, it gives "1" as it counts the packetloss for all participants based on the criteria given.  and when I drilldown to participantname, there wont be any participants with packetLoss >5 for morethan 3 times in the meeting. 

 

So i need to calculate per participant.