Sum of measure is displayed. I don't want that

[crabcatcherAK]

I apologize if this isn't the best format or area to post, I just registered for the community a few minutes ago. 

**The highlighted measure total is what I don't want 'added' up. I want the average ratio to be displayed. How to make that happen? 

[Anonymous]

Hi @crabcatcherAK 

Has your problem been solved ? If it has been solved, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards

Community Support Team _ Ailsa Tao

[crabcatcherAK]

To clarify, the 2017 ratio(top left visual) is a calculated column. Dax =  taking the sales price / FV total = ratio. This calculated column is what is displayed in the visual but I don't want the total 'sum' at bottom, I want the average. 

1. should i keep as calculated column and create new measure or, 

2. create measure to get my ratio's and then displaying them should be cleared up? 

again, sorry about the format of this question, brand new to power bi and the community. 

[AlexisOlson · Accepted solution]

A measure seems like the better option to me.

Try this as a measure:

2017 Ratio =
DIVIDE ( SUM ( Table1[FV Total] ), SUM ( Table1[SalePrice] ) )

[crabcatcherAK]

I will give it a shot. Thanks for the input. Let you know in morning. 

[Anonymous]

You have to create measures. Once you have a measure that works on the individual PID level, say its name is [PID Level Measure] (should be hidden), then you create this general measure:

[Ratio] =

averagex(

    distinct( T[PID] ),

    [PID Level Measure]

)

[crabcatcherAK]

Sorry for stupid  question to follow here... Whats the difference? 

The original measure, created on the PID level, is

**2017 sales ratio 2 = DIVIDE(SUM(_2017_all_data[FV Total]),SUM(_2017_all_data[SalePrice]))

What is the difference between that measure and this one, 

**2017 Ratio 3 = AVERAGEX(DISTINCT(_2017_all_data[PID]),_2017_all_data[2017 sales ratio 2]).

 Here is a picture of the different totals (averages), why are the numbers displayed different? Ratios are the same down the columns but totals are not? 

[AlexisOlson]

You are changing the aggregation for the [FV Total] measure, not the [2017 ratio] measure you have highlighted in your visual. Try using the dropdown for [2017 ratio] in the pane on the right instead of the dropdown for [FV Total].