Creating a calculated measure for average percent

[Anonymous]

Hello Power BI DAX Commanders,

I hope that all is well. Can you help me troubleshoot my dax code?

Calculated measure

Percent = DIVIDE(

    [Total Responses],

    CALCULATE(

        [Total DF],

        ALL('Survey Fact')

    )

)

In the matrix, I want to replace the 100% with an average percent.

Transform Data	Responses	Percent
Join Data sets	22	91.67%
Map fields	17	70.83%
Transform from wide to long	16	66.67%
Union Data Sets	16	66.67%
	Average Percent	73.96%

I can use Excel to calculate the output =Subtotal(1, Ave(C2:C6).

Here is the link to the PBIX and data source files. Winter Survey

Any nudge is greatly appreciated.

Luis Pablo Martinez

[lbendlin · Accepted solution]

[quipmastere]

@lbendlin - this is correct! How did you come up with your solution? Thank you.

I am the orignal poster. I just changed jobs and cannot reply from my original profile.

Could the moderator please mark @lbendlin reply as the solution?

Thank you again.