Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Newbie here that needs some help.
I am trying to do some statistical anlaysis of network performance data. The key attribute I would like to do the analysis on is called values. Within values are positive whole integers. Thus far, I can get the min, max, average, and standard deviation. Through a lookup table, I am able to calculate a value depending on how many standard deviations one is away from the average.
What I would like to be able to do, is for a given standard deviation value, count how many data points are above that value. I have tried many different methods to do this, but I keep hitting a wall and cannot get it to work.
Here is what my current overview tab looks like. for the CutoffValues, I would like to get a sense of how many rows have values greater than the cutoffvalues.
The measure Z is computed by:
Solved! Go to Solution.
Try this slightly modified version:
CountedValues V2 =
VAR aux_ = [CutoffValues]
RETURN
CALCULATE (
COUNT ( 'pdom_onprem_connected-sessions_30s_60d'[values] ),
FILTER (
ALL ( 'pdom_onprem_connected-sessions_30s_60d'[values] ),
'pdom_onprem_connected-sessions_30s_60d'[values] > aux_
)
)
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
Hi @jasonrap
Assuming no relationship between the two tables, create a measure and place it in the table visual you are showing:
Measure =
CALCULATE (
COUNT ( 'myTable'[values] ),
FILTER ( ALL ( 'myTable'[values] ), 'myTable'[values] > [CutOffValues] )
)
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
Thank you for the reply, I really do appreciate it!
I created the following measure:
CountedValues = CALCULATE(COUNT('myTable'[values]),FILTER(ALL('myTable'[values]),'myTable'[values]>[CutoffValues]))
Hi @jasonrap ,
Any chance you could provide a sample pbix file?
Thanks,
Proud to be a Super User!
Sure, here is a link to the file: https://drive.google.com/file/d/1YB2jAJrENQpHB22biQjdJWHpIAtpTDG-/view?usp=sharing Hopefully that link works. Thank you!
Hi @jasonrap,
Looking now
Proud to be a Super User!
Hi @jasonrap,
try the following
CountedValues =
var cv = (stdev.p('pdom_onprem_connected-sessions_30s_60d'[values])*sum(SD[SDs to enumerate through])+AVERAGE('pdom_onprem_connected-sessions_30s_60d'[values]))
return
CALCULATE(COUNTX('pdom_onprem_connected-sessions_30s_60d', [values]),
FILTER(all('pdom_onprem_connected-sessions_30s_60d'),
'pdom_onprem_connected-sessions_30s_60d'[values]>cv)
)
Hope this Helps,
Richard
Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!
Proud to be a Super User!
Try this slightly modified version:
CountedValues V2 =
VAR aux_ = [CutoffValues]
RETURN
CALCULATE (
COUNT ( 'pdom_onprem_connected-sessions_30s_60d'[values] ),
FILTER (
ALL ( 'pdom_onprem_connected-sessions_30s_60d'[values] ),
'pdom_onprem_connected-sessions_30s_60d'[values] > aux_
)
)
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
Richard and Super User III, thank you both for helping me with this!!! I grealy appreciate the assistance! Bravo!
User | Count |
---|---|
79 | |
74 | |
44 | |
32 | |
28 |
User | Count |
---|---|
104 | |
93 | |
52 | |
50 | |
46 |