Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |