topic Re: trying to average a measure in DAX Commands and Tips

trying to average a measure

Anonymous — Wed, 24 Jan 2024 16:50:17 GMT

Hello Power BI DAX superstars,

I am stuck on DAX. Any guidance is greatly appreciated.

What am I trying to do?

Create a measure that averages an existing measure.

Current Measures:

Total DF = CALCULATE( [Total Responses], CROSSFILTER( DF_Dim[Response ID], 'Survey Fact'[Response ID], Both ) )

Percent = DIVIDE( [Total Responses], CALCULATE( [Total DF], ALL('Survey Fact') ) )

New Measure:

ave % = AVERAGEX('Survey Fact', [Total Responses])

I envision creating a measure that will average the percent measure in the matrix.

The ave% measure does not give the envisioned output.

Here is a link to the PBIX and data source.

PBIX File

Re: trying to average a measure

Anonymous — Thu, 25 Jan 2024 02:26:00 GMT

Hi Anonymous ,
Based on the pbix file you provided, I tried to create a new meaure based on the meaure you created for the purpose you want to calculate the average ratio.
Create a measure:

Average Percent = AVERAGEX( VALUES('Survey Fact'[Response ID]), [Percent] )

Fianl output

Best regards

Albert He

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

Re: trying to average a measure

Anonymous — Thu, 25 Jan 2024 20:14:23 GMT

Hi Anonymous ,

Thank you for your reply.

I did not pose my question, correctly.

Here is my matrix.

My goal: create a measure that gives me an average percent.

For example, in Excel, I can perform the following.

Transform Data	Percent
Join datasets	91.67%
Map fields between tables	70.83%
Transform from wide to long	66.67%
Union datasets	66.67%
Average Percent	73.96%

I can calculate the average percent with the following excel formula, =Subtotal(1, B2:B5).

What would the equivalent be in DAX?

Any nudge is greatly appreciated.

Luis Pablo Martinez

Re: trying to average a measure

sjoerdvn — Fri, 26 Jan 2024 09:36:48 GMT