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] ) )
    )
)
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.