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.
Hi PBI Community,
I'm looking to plot a rolling 12 month Standard Deviation of the Complaint Rate line, which is a measure of Complaints Number divided by 3 Month Sales Average (both numerator and denominator are also measures). I'm under the impression that STDEV.S can only be applied to a column, so I'm hoping to get some help on how to work around this. A measure of a calculated column works for single selected Sub Categories but not for combinations of multiple Sub Categories, which is what this report will primarily use.
Thank you!
@Hi @ARLFG
perhaps someone like this?
STD =
VAR CurrentMonth =
SELECTEDVALUE ( 'Date'[Month] )
RETURN
MAXX (
FILTER (
ADDCOLUMNS ( ALLSELECTED ( 'Date'[Month] ), "@STD", STDEV.S ( [Measure] ) ),
'Date'[Month] = CurrentMonth
),
[@STD]
)
I'm trying to do something similiar and think the solution has to be somehow using summarize/summarize columns and creating a virtual table to calculate the Standarad Deviation off of. Is that possible or has anyone done that before?
User | Count |
---|---|
25 | |
12 | |
8 | |
6 | |
6 |
User | Count |
---|---|
26 | |
12 | |
12 | |
10 | |
6 |