Forum Discussion
Responsive ResidentCount of rows based on multiple column
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
Community ChampionYou have to share the URL to the file hosted elsewhere: Dropbox, Onedrive... or just upload the file to a site like tinyupload.com (no sign-up required).
Try this new measure, based on the one you have:
Measure =
SUMX ( DISTINCT ( Table1[ParticipantName] ), [PacketLoss?] )
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
Responsive ResidentIm working on the sample workbook for you. Meanwhile, I need a flag with 1 or 0 to tell the user that this meeting has packetloss issues. The Sumx, sums the values right?