trying to average a measure

[Anonymous]

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

[sjoerdvn]

[Anonymous]

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

[Anonymous]

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