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'm a beginner on power bi. I am trying to calculate the average and the standard deviation for a group of durations. I have created measures that calculate on other measures and I am not sure how they work. The intention is that the measures can be filtered using other fields from the main table. I would be grateful for any feedback.
The first measure calculates the sum of a duration of a status across a number of rows.
DAX measures execute inside the current filter context on the report. If you have a measure in a visual that is displaying rows by category, then the measure will only operate on the rows for that category.
This is why sometimes you need to use the ALL() function inside of CALCULATE(), to restore a greater set of the rows than are visible to the measure in the filter context when it is called.
I'm a personal Power Bi Trainer I learn something every time I answer a question
The Golden Rules for Power BI
Help when you know. Ask when you don't!
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 |
---|---|
41 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
44 | |
32 | |
30 | |
18 | |
17 |