Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Hi @BenGWeeks ,
If [Area] is a determined value,
Try below measure:
AVERAGE=CALCULATE(AVERAGE(DevOpsAssessmentResponses[Area]),FILTER(ALL('DevOpsAssessmentResponses'),DevOpsAssessmentResponses[Area]="XXXXX"))
If [Area] is dynamic,
Try below measure:
AVERAGE=CALCULATE(AVERAGE(DevOpsAssessmentResponses[Area]),FILTER(ALL('DevOpsAssessmentResponses'),DevOpsAssessmentResponses[Area]=MAX(DevOpsAssessmentResponses[Area]))
Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!
Hi @BenGWeeks ,
If [Area] is a determined value,
Try below measure:
AVERAGE=CALCULATE(AVERAGE(DevOpsAssessmentResponses[Area]),FILTER(ALL('DevOpsAssessmentResponses'),DevOpsAssessmentResponses[Area]="XXXXX"))
If [Area] is dynamic,
Try below measure:
AVERAGE=CALCULATE(AVERAGE(DevOpsAssessmentResponses[Area]),FILTER(ALL('DevOpsAssessmentResponses'),DevOpsAssessmentResponses[Area]=MAX(DevOpsAssessmentResponses[Area]))
Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!
Use SELECTEDVALUE() or MIN() / MAX() etc depending if you care about totals being meaningful.
You need to capture SELECTEDVALUE before you do CALCULATE(), by assigning a variable. below example illustrates the point but is a bit useless as the "current row" is already in the context, so it is not necessary to filter like this.
AVERAGE =
var a = SELECTEDVALUE(DevOpsAssessmentResponses[Area])
return CALCULATE(AVERAGE(something something),DevOpsAssessmentResponses[Area]=a)
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 |
---|---|
76 | |
71 | |
56 | |
39 | |
35 |
User | Count |
---|---|
66 | |
66 | |
59 | |
53 | |
45 |