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.
Hi!
I am scratching my head with this one, and am obviously missing something. Seems to be some calculation difference between a variable and a measure reference?
I have two measures intended to display a cumulative average month by month, one of the measures has a variable with some calculation in it. This measure displays the wrong result.
If I however put the same piece of code in a separate measure and reference that measure instead of having it in a variable, it displays the correct result.
What is causing the same piece of code to render different results depending on it being in a measure vs. a variable. Pictures below.
Below is the code which is used in the two other measures following further down:
This gets me the average number of tickets per year-month:
These two measures below are using the above code in two different ways:
So as you can see the code in the first picture is being used both as a variable and as a measure reference in a calculate statement.
Why am I getting different results with the same code?
Solved! Go to Solution.
When calculated as a variable first it is in the evaluation context of the visual. Putting the variable inside the CALCULATE(variable, FILTER(... does not recalculate the expression in the desired new evaluation context.
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
When calculated as a variable first it is in the evaluation context of the visual. Putting the variable inside the CALCULATE(variable, FILTER(... does not recalculate the expression in the desired new evaluation context.
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
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 |
---|---|
102 | |
101 | |
78 | |
69 | |
63 |
User | Count |
---|---|
141 | |
106 | |
101 | |
85 | |
72 |