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

     

     

     

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.

ovinasca's avatar
ovinasca
Frequent Visitor
8 years ago

 

 

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    8 years ago

    OK, so what would that look like if it was aggregated by the "time dimension"?

    • ovinasca's avatar
      ovinasca
      Frequent Visitor
      8 years ago

      That's TOTAL(2) in the picture, and if you aggregate by department dimension you whould obtain TOTAL (1)

      • ovinasca's avatar
        ovinasca
        Frequent Visitor
        8 years ago

        Hope it helps.... 

         

        Maybe it's not possible....

         

        Thanks!