shieldsco

<div>
<div class="content wysiwyg-content fr-view">
Trying to create a DAX measure that totals the average of the Goal column.<a href="https://filedb.experts-exchange.com/incoming/2021/11_w48/1578627/1638048483621.png" rel="ugc"><img src="https://filedb.experts-exchange.com/incoming/2021/11_w48/1578627/1638048483621.png" class="fr-fic fr-dib"></a> <pre><code class="code-1 nolinks" id="code-10-29228938-1">Goal = Var AvgGoal=AVERAGE('OMHA-- Field Office Disposition'[Monthly Goal]) Return
If(HASONEVALUE('OMHA-- Field Office Disposition'[FiscalMonth]),
AvgGoal,
SumX(VALUES('OMHA-- Field Office Disposition'[FiscalMonth]),AvgGoal))

</code></pre>
</div>
</div>

1638048483621.png


Trying to create a DAX measure that totals the average of the Goal column.
Goal = Var AvgGoal=AVERAGE('OMHA-- Field Office Disposition'[Monthly Goal])
Return
If(HASONEVALUE('OMHA-- Field Office Disposition'[FiscalMonth]),
AvgGoal,
SumX(VALUES('OMHA-- Field Office Disposition'[FiscalMonth]),AvgGoal))

Power BI Measure Sum an Average Column

Power BI is a business analytics tool from Microsoft used for data visualization. It integrates seamlessly with other tools, like Microsoft Excel, and is easily embedded in websites and apps. Power BI offers live dashboards and visual reports to help “bring your data to life.” There are many opportunities for customization, as well as built-in options for your visualizations and analytics. With the Power BI mobile app, you can receive push notifications about important data changes, allowing you to react and plan right away.

Power BI

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.