topic Re: Creating a calculated measure for average percent in DAX Commands and Tips

Creating a calculated measure for average percent

Anonymous — Fri, 26 Jan 2024 16:59:45 GMT

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.

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 — Sat, 27 Jan 2024 02:56:58 GMT

quipmastere — Sat, 27 Jan 2024 21:49:52 GMT

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.