Default Summarization

[EnochS]

Hello,

I'm trying to change the column total to be an average, instead of summarized, for some percentages. As you can see below, the average is not correct:

 

I have my data housed in a SQL Database and most of the calculations are done in the ETL process so my data is mostly ready to go for Power BI. The calculations that I use in Power BI are for data that are in multiple tables so I have used "Measures":

For some reason I can't change the "Default Summarization" Settings. It's greyed out. I'm assuming you cannot change that for measures..

 What are my options to change this since summarized %'s are not correct. I would like them to be averages. It seems that I could potentially create a custom column (like the picture above ("Job_#), but if there is a simpler way then that would be best. Please let me know if you know what can be done.

Thank you,

[v-haibl-msft · Accepted solution]

@EnochS

If you already have a measure for % Net Profit, please try to create another measure with following DAX expression.

Measure = 
AVERAGEX ( A_Job ID, [% Net Profit] )

Best Regards,

Herbert

[EnochS]

Thank you!

That looks like it is the answer that I was looking for. I realized that I actually made a mistake regarding the needed calculation. An average of the % net profit, vs the total % net profit are two different numbers and will give us two different numbers because it's basically just telling us our success rate, vs the total success that we've had. The original numbers and calculation was correct. 

The measure you provided though can come in handy so that we can see what the average % net profit we do actually get on a regular basis and let's us see if wee need to improve in our operations or company overhead.

Thank you for taking the time to solve this.