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 

     

     

AlB's avatar
AlB
Icon for Community Champion rankCommunity Champion
5 years ago

Hi LP2803 

The second pic is not readable. Too small.

Can you share the pbix?

 

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

 

AlB Thanks for the response, Sorry im unable to attach the pbix here.  Below is the better image i think. 

 

Notice the underlined meetinginstanceid, it shows 1 for packetloss indicating that this meeting has packetloss issues morethan 3 times which is not correct becuase its calculating for the overall meeting and not per participantname.   

 

when i expand to the participant level (image below),  the packetloss column becomes 0, which is actually correct since no participants are having morethan 3 times of packet loss in their meeting.