Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Overall and detailed average

Hello,   I'm trying to display the data in a matrix the way I liked but I cannot get the expected presentation.   My report is composed by 4 slicers : The name of an expert The service The ch...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    HI Anonymous,

     

    All function will ignore filter effect so your formula get similar result on each row.
    I'd like to suggest you test with below formula if it suitable for your requirement:

    Measrue =
VAR total =
    CALCULATE (
        AVERAGE ( 'mission_exp'[Fees closed claims] );
        ALL ( 'mission_exp' )
    )
RETURN
    IF (
        ISFILTERED ( mission_exp[Mission type detail] );
        ( total + AVERAGE ( 'mission_exp'[Fees closed claims] ) )
            / 2;
        AVERAGE ( 'mission_exp'[Fees closed claims] )
    )

     

    Regards,

    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
8 years ago

HI Anonymous,

 

All function will ignore filter effect so your formula get similar result on each row.
I'd like to suggest you test with below formula if it suitable for your requirement:

Measrue =
VAR total =
    CALCULATE (
        AVERAGE ( 'mission_exp'[Fees closed claims] );
        ALL ( 'mission_exp' )
    )
RETURN
    IF (
        ISFILTERED ( mission_exp[Mission type detail] );
        ( total + AVERAGE ( 'mission_exp'[Fees closed claims] ) )
            / 2;
        AVERAGE ( 'mission_exp'[Fees closed claims] )
    )

 

Regards,

Xiaoxin Sheng