Forum Discussion

ovinasca's avatar
ovinasca
Frequent Visitor
8 years ago
Solved

Measure aggregated based on dimensions

Hi all!   I need to create a measure that aggregates based on dimensions, I mean, when its aggregated by the Time Dimension I need to SUM the values but when its aggregated by the Department Dimens...
  • Vvelarde's avatar
    Vvelarde
    8 years ago

    ovinasca

     

    Hi, try with this Measure in Values Section

     

    Measure =
IF (
    HASONEVALUE ( Table1[TIME] );
    SUM ( Table1[FTE's] );
    AVERAGE ( Table1[FTE's] )
)

    Regards

     

    Victor

    Lima - Peru

     

     

     

  • ovinasca's avatar
    ovinasca
    Frequent Visitor
    8 years ago

    Sorry and thanks for the post you suggested!!!

     

    The pìcture shows what should be the final result. We have a measure called FTE's with two dimensions, WEEK and DEPARTMENT.

     

    I want the values of FTE's to be aggregated as SUM when working with WEEK (Time) Dimension and I want them to be aggregated as AVERAGE when working with DEPARTMENT Dimension.

     

    Hope if helps.

     

    Thanks!!

    Regards

      • Greg_Deckler's avatar
        Greg_Deckler
        Community Champion
        8 years ago

        ovinasca- What would be very helpful is if you could share the source data that results in the totals that you shared.