Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Calculating the Difference between two averages

Hello! I would like to ask you for some advices how to calculate one new measure based on column rebate average%, MSE SD%, Total SD% seperately.    Example based on total SD% column: 1. Average f...
Need Help
  • BarnabasToth's avatar
    BarnabasToth
    4 years ago

    Hi there,

    You can use this approach (see link for file😞

    Difference compared to average =

VAR AverageOfValue = AVERAGE('Table'[Value])

VAR AverageOfTotal = 
CALCULATE(
    AVERAGE('Table'[Value]),
    ALLSELECTED('Table'[Chain])
)

VAR Result = AverageOfValue - AverageOfTotal

RETURN
Result

     

    Using ALLSELECTED changes the average at the total row in case only a subset of chains are selected.

    If this answers your question, please mark this as a solution.

    Regards,
    Barna

BarnabasToth's avatar
BarnabasToth
Resolver I
4 years ago

Hi there,

You can use this approach (see link for file😞

Difference compared to average =

VAR AverageOfValue = AVERAGE('Table'[Value])

VAR AverageOfTotal = 
CALCULATE(
    AVERAGE('Table'[Value]),
    ALLSELECTED('Table'[Chain])
)

VAR Result = AverageOfValue - AverageOfTotal

RETURN
Result

 

Using ALLSELECTED changes the average at the total row in case only a subset of chains are selected.

If this answers your question, please mark this as a solution.

Regards,
Barna