Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 my data looks like.
I have MeetingInstanceID, ParticipantName, Attribute2, Value as columns.
This is the meeting information in my organisation and all attributes (packetloss, latency etc... ) are recorded at 1 min interval for every meeting. In this data "Value" column is the values recorded at each min for each attribute, participantname, meetinginstanceid.
I need to create a flag for each meetinginstanceid when it meets the below criterias.
1. participant hitting latency of >400 for morethan 5 times in a meeting
2. participant hitting packetloss of >5 for morethan 3 times in a meeting
then flag that meeting as 1 or something so that my manager can know this meetinginstanceid needs attention.
My output to my manager looks as below :
Solved! Go to Solution.
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
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
Perfect. it worked. Thanks a lot.
I will definitely contact you privately for some DAX tutorial sometime.
You 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
Im 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?
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
@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.
currently the latency? packet? measures (with below DAX) i have in the view are working fine but not considering the participantname in them.
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.
User | Count |
---|---|
128 | |
108 | |
100 | |
64 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |