Forum Discussion

Jos_Woolley's avatar
Jos_Woolley
Icon for Solution Sage rankSolution Sage
5 years ago

Hi,

You mean this?

Measure =
IF (
    HASONEVALUE ( 'Table'[Category] ),
    AVERAGE ( 'Table'[Total result] ),
    DIVIDE ( SUM ( 'Table'[Total result] ), SUM ( 'Table'[Category] ) )
)

Regards

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Thank you, but not, the first part is OK

    IF (
    HASONEVALUE ( 'Table'[Category] ),
    AVERAGE ( 'Table'[Total result] ),

    The problem is with second.

    I need also the sum average.

     

    Now I am using

    Total R = IF(HASONEVALUE(Table'[Name], AVERAGE( 'Table'[Total result] ), SUMX( Table, AVERAGE ( 'Table'[Total result] ) / SUM(Table[Category])).

     

    I don´t Know Why?

    But, Only it´s working if I filter "1 visit" by: Advanced filtering/ is no blank.

    And I don´t know why I need  that filter. I don´t have any blank and only it´s working If I do the filter on "1 visit".

    I have other table "Regions" and the masure it´s working ( with the filter is no Blank) in all Regions except two