How to calculate the average on Total of measure columns?

[Anonymous]

Hi All,

Can you tell me please how to see the average of the totla of 4 measure columns.

example on below image, the totla column of "total cost of festool per unit " showing a strange number, it is  the sum of those column & average aswell. but i am interested to calculate the sum for each row, and the average of all the sum total of the last column. 

any help and ideas are highly appreciated

[Syndicate_Admin]

You can get your data by using a calculated column. Here's a tutorial on how to create those:

Tutorial: Create calculated columns in Power BI Desktop - Power BI | Microsoft Docs

[v-kelly-msft · Accepted solution]

Hi  @Anonymous ,

Create a measure similarly as below:

Total Measure = 
var _total='Table'[Measure 1]+'Table'[Measure 2]+'Table'[Measure 3]+'Table'[Measure 4]
var _distinct=CALCULATE(DISTINCTCOUNT('Table'[category]),ALL('Table'))
Return
IF(ISINSCOPE('Table'[category]),_total,DIVIDE(_total,_distinct))

 And you will see:

For the related .pbix file,pls see attached.

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!