Measures in a calculated summarized table

[orangeatom]

Hello, 

I am in need of some thoughts on how I can solve this issue. I have an aggregated measure (column "result" below) to which I would like to preform simple calculations on such as average and muliplication without impacting and contributing to its calculation. In the table below that is the "result" column.

I would then like to take the "result" column and average it by the indicator.

Futher I would like to take the "average" column and multiply it by the count of indicators.

Indicator Measure Result                               Average Multipler
1             1              0                                      43.3       14.3
               2              115    
               3              15    

-----------------------------------------------
2             4              200                                  200          66

-----------------------------------------------

3             5              75                                    87.5         28.875
               6             100  

-----------------------------------------------

I have tried to go about this by creating a table and using the Summarize function however i'm not getting the expected result. I have tried to get the sum(result) / count(measure) however it is not producing the result i expect.

Thank you! 

[Greg_Deckler]

I'm not clear on where the Multiplier comes from.

Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

[orangeatom]

sorry about that, the multipler colum is based the count of indicators:

Indicator Measure Result                               Average                                               Multipler
1             1              0                                      43.3       (Multiply count indicator (3)) 14.3
               2              115    
               3              15    

-----------------------------------------------
2             4              200                                  200        (Multiply count indicator (3)) 66

-----------------------------------------------

3             5              75                                    87.5       (Multiply count indicator (3)) 28.875
               6             100  

-----------------------------------------------