Forum Discussion
LP2803
5 years agoResponsive Resident
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...
- 5 years ago
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
5 years agoCommunity Champion
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
- LP28035 years agoResponsive Resident
Perfect. it worked. Thanks a lot.
I will definitely contact you privately for some DAX tutorial sometime.