Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
Hi! This is my first post, but I can't seem to find my answer anywhere even though it seems like a simple problem. I'm pretty new to PBi so there are things I just don't understand yet. Ok here is my problem:
My goal: Find the standard deviation of the dataset from the beginning of my step change to the present time (my data is being reported every 15 minutes).
My problem: I have created a measure that finds the beginning of the step change, using an index column as a reference. In the example it is indexed at 13,902. This is great, but when I use that measure to find the standard deviation, I only get (Blank) as an answer. If I manually enter in 13902 to the measure finding my standard deviation, it computes the correct answer (I checked on excel).
My question: If the two number are the same (and seemingly of the same datatype, General), why does one work and the other returns a (Blank)?
Here is the code I am using to find each measure, and my outputs:
This code finds the last time the step occured:
IndA DP Step Date =
var step = CALCULATE(LASTNONBLANK(MACT_15MIN_AVG[StepDate],MACT_15MIN_AVG[StepDate]))
return
CALCULATE(SUM(MACT_15MIN_AVG[Index]),MACT_15MIN_AVG[StepDate]=step)
This code is actually calculating the standard deviation:
IndA DP StdDEV = CALCULATE(
STDEV.S(MACT_15MIN_AVG[A108DC01DIFF_PRES15MN_AVG_VAL0]),
FILTER(MACT_15MIN_AVG,MACT_15MIN_AVG[Index]>[IndA DP Step Date]))
Here is a picture of my outputs, the first using my IndA DP Step Date measure, the second manually entering the same number as the measure into the filter.
You should learn about context transition before you start writing any formulas. There are lots of free DAX courses on YT. Please try to first learn the basics of DAX because without the theory you'll be struggling and get frustrated in no time.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
14 | |
10 | |
10 | |
9 | |
9 |
User | Count |
---|---|
20 | |
13 | |
12 | |
11 | |
8 |