Forum Discussion

sr001's avatar
sr001
New Member
8 years ago
Solved

Multiply measure by column and sum total

Hello All,   I have read the other discussions on this topic and am still having issues with my report.      I am trying to create a measure (or column) which will multiply Hours by Av...
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

    HI sr001

     

    I am not sure... but please give a SHOT to this MEASURE

     

    MEASURE=
IF (
    HASONEVALUE ( '001'[Grade] ),
    SUM ( '001'[Hours] ) * AVERAGE ( 'ESR Rates'[ColumnName] ),
    SUMX (
        ALLSELECTED ( '001'[Grade] ),
        CALCULATE ( SUM ( '001'[Hours] ) )
            * CALCULATE ( AVERAGE ( 'ESR Rates'[ColumnName] ) )
    )
)
Zubair_Muhammad's avatar
Zubair_Muhammad
Icon for Community Champion rankCommunity Champion
8 years ago

HI sr001

 

I am not sure... but please give a SHOT to this MEASURE

 

MEASURE=
IF (
    HASONEVALUE ( '001'[Grade] ),
    SUM ( '001'[Hours] ) * AVERAGE ( 'ESR Rates'[ColumnName] ),
    SUMX (
        ALLSELECTED ( '001'[Grade] ),
        CALCULATE ( SUM ( '001'[Hours] ) )
            * CALCULATE ( AVERAGE ( 'ESR Rates'[ColumnName] ) )
    )
)
  • sr001's avatar
    sr001
    New Member
    8 years ago

    Thank you Zubair_Muhammad !! 

     

    That has worked perfectly, your help is much appreciated. 

     

    I see (and think I understand the need for) that you have used SUM and SUMX, but what is the requirement for the HASONEVALUE line please.

     

    Again, many thanks for your help.