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.
I have a table with survey results. I have calculated measures that counts the number of positive feedback, neutral feedback, negative back, and one measure that counts all of them together:
I've also created measures that calculates the percentage of each. The formulas are simply:
Positive Feedback/All Groups
Negative Feedback/All Groups
Nuetral Feedback/All Groups:
These measures are all calculating 2 years worth of data. What I'm trying to figure out is the average for the previous quarter for positive feedback. I constructed a formula that looks like this:
Which I assumed was a no brainer however, this formula for some reason is returning the exact same value as my overall Positive % rather than just the last quarter:
I know it is incorrect because if I take the survey dates and put them on a slicer and select only the dates that fall in the previous quarter, my positive % comes out to a different %:
So I know the percentage should be 65.62%. Any idea why the previous quarter function isn't working properly?
In the Last Quarter Satisfaction measure, maybe try using the while formula for [Positive %] instead of using the column as is.
@Anonymous I'm not super positive what that is. I've gotten it working now but in the formula I'm just now hardcoding the year and the quarter to get myre results. While this works, I would have to go in and update this every quarter and when a new year arrives. Not a big deal but I don't want to accidentally forget to do so. Other measures and calculations rely on this one...
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 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |