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

     

     

     

v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
8 years ago

Hi ovinasca,

 

Can you share a sample please? In other words, can we take the non-total values as the original data?

 

Best Regards,

Dale

ovinasca's avatar
ovinasca
Frequent Visitor
8 years ago

Yes it is!

 

The non total values are the original data and the total values should be the aggregation output depending on the dimension. 

 

The picture shows what would be the final result

 

Thanks!!!